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

60 votes454 views6 answers
Add column in sql
SQL
0 vote277 views1 answer
Show database not empty tables postgres
SQL
0 vote315 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote263 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote274 views1 answer
Create mysql pool connection python flask
SQL
1 vote270 views3 answers
Postgresql crete view
SQL
1 vote286 views1 answer
Table information in sql server
SQL
2 votes292 views1 answer
Can you use a where clause for a child query
SQL
0 vote271 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
1 vote276 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL