Sql show tables

Get the list of all tables in sql server

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

How to get all table names in sql query

BY LOVE SINGHSELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

Sql show tables

Showing all table: 
show tables;

Showing table data:
SELECT
* or column_names
FROM
table_name;

Mariadb show tables

SHOW TABLES FROM database

How to check table name in current database sql

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=db_name() 
and TABLE_NAME like'%table_name%'--to check particular table

Similar codes

0 vote343 views1 answer
Mysql read row
SQL
11 votes357 views3 answers
Change column name sql server management studio
SQL
1 vote344 views1 answer
Simple project for database
SQL
1 vote336 views1 answer
Minus vs intersect in sql
SQL
10 votes353 views5 answers
Mysql create user
SQL
13 votes289 views2 answers
Oracle all source
SQL
6 votes366 views1 answer
Postgres get size of database
SQL
9 votes360 views5 answers
Laravel to sql
SQL
0 vote367 views1 answer
Copying query result to excel
SQL
0 vote287 views1 answer
How to connect sql server using ip address in c#
SQL