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

1 vote249 views1 answer
Postgres concat_ws
SQL
0 vote262 views1 answer
Openquery update linked server
SQL
0 vote198 views1 answer
Denied
SQL
1 vote237 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote283 views1 answer
Mysql average from two table
SQL
0 vote255 views1 answer
Odd record sql query
SQL
0 vote241 views1 answer
Show all mongodb
SQL
0 vote272 views2 answers
Dumping sql table
SQL
0 vote195 views1 answer
Oracle sql replace string in clob
SQL
3 votes536 views1 answer
Postgresql cast
SQL