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

11 votes343 views2 answers
Safe mode off mysql
SQL
3 votes419 views1 answer
Mysql cli connect with password
SQL
0 vote359 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
22 votes381 views4 answers
Mysql date_format
SQL
0 vote383 views1 answer
000webhost database values insert
SQL
0 vote391 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote347 views1 answer
Oracle flush Shared Pool
SQL
2 votes374 views1 answer
Oracle kill job by sid
SQL
3 votes358 views2 answers
Oracle privileges users
SQL
0 vote383 views1 answer
Postgresql like
SQL