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

14 votes115 views3 answers
Oracle sql limit results
SQL
29 votes98 views6 answers
Delete all rows from table mysql
SQL
2 votes100 views1 answer
Get first 3 letters name in sql
SQL
0 vote101 views1 answer
Mysql search multiple tables
SQL
0 vote121 views1 answer
Sql select sum group by id laravel join
SQL
0 vote103 views2 answers
Imageview setimageresource null
SQL
12 votes102 views2 answers
Delete all nodes neo4j
SQL
51 votes208 views6 answers
Opera gx
SQL
3 votes111 views1 answer
Select database in sql
SQL
0 vote118 views1 answer
Sql bild in function
SQL