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 vote160 views1 answer
Day of the week sqlite
SQL
2 votes134 views2 answers
Select list is not in group by clause
SQL
13 votes119 views6 answers
Mysql update from select
SQL
0 vote134 views1 answer
Plsql find location of procedure
SQL
0 vote129 views1 answer
Mysql date format unix timestamp
SQL
0 vote132 views1 answer
Rabbitmq ui not working
SQL
3 votes153 views5 answers
Foreign keys
SQL
0 vote120 views1 answer
Call function in query sql server
SQL
0 vote124 views1 answer
Remove default constraint sql server
SQL
0 vote142 views1 answer
Postgresql replace html tags from string
SQL