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

-1 vote286 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
13 votes293 views3 answers
Sql select from multiple tables without join
SQL
0 vote264 views1 answer
Oracle list dblink
SQL
0 vote272 views1 answer
Oracle drop default value
SQL
0 vote480 views1 answer
The differnece between to values in sql
SQL
0 vote298 views1 answer
Duplix print in Smartforms
SQL
0 vote307 views1 answer
Will graphql replace sql
SQL
0 vote277 views1 answer
Porcentaje sql
SQL
1 vote288 views1 answer
Mariadb case switch
SQL
0 vote257 views1 answer
Sqlite3 now
SQL