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

3 votes215 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote195 views1 answer
SQL isnumeric DB2
SQL
2 votes199 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote194 views1 answer
How many columns can be used for creating index?
SQL
2 votes250 views2 answers
Postgres drop column if exists
SQL
0 vote263 views1 answer
Postgres select from values
SQL
0 vote198 views1 answer
Conda install pymysql "windows"
SQL
0 vote204 views1 answer
What does leave do in mysql
SQL
5 votes214 views3 answers
String concatenation sql server
SQL
1 vote200 views1 answer
Raise application error in oracle
SQL