How to get all tables in sql

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 tables in sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

Sql query to list all tables in a database sql server

BY LOVE SINGH on May 19 2020SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

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 vote156 views1 answer
Linebreak sql
SQL
0 vote198 views1 answer
Oracle show running job
SQL
0 vote179 views1 answer
Implode in sql query
SQL
0 vote187 views1 answer
Wordpress make wp user in db
SQL
7 votes145 views2 answers
Show size database mysql
SQL
0 vote148 views1 answer
Mysql repair a table
SQL
0 vote150 views1 answer
What is metadata in sql
SQL
0 vote150 views2 answers
Check mysql timezone
SQL
20 votes165 views4 answers
Reset auto increment in MySQL
SQL
0 vote149 views1 answer
Optimize sql query
SQL