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 vote197 views1 answer
How to install mysql 8.0 windows service
SQL
2 votes195 views1 answer
Postgresql add entry to table
SQL
1 vote197 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
16 votes221 views5 answers
Select last row in sql
SQL
0 vote203 views1 answer
Kill a pid redshift
SQL
1 vote263 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote211 views2 answers
Coursera spark sql max count
SQL
0 vote232 views1 answer
Consecutive numbers sql
SQL
0 vote248 views1 answer
Oracle sql date winter time
SQL
3 votes208 views1 answer
Show index table
SQL