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 vote248 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote266 views1 answer
Less than date query sqlachemy
SQL
0 vote251 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
3 votes268 views1 answer
Oracle APEX elapsed time
SQL
3 votes240 views1 answer
V$session not found in oracle
SQL
0 vote229 views1 answer
Mysql sleep connections
SQL
0 vote260 views1 answer
View to table sql
SQL
1 vote281 views1 answer
What is in condition in sql
SQL
3 votes238 views2 answers
Having in mysql
SQL
1 vote256 views1 answer
Mysql query bulk insert
SQL