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 vote305 views2 answers
Mysql insert into multiple tables
SQL
20 votes310 views4 answers
How to find average in sql
SQL
-1 vote288 views1 answer
Phinehas Psalm 106
SQL
0 vote264 views1 answer
Oracle date summer time
SQL
0 vote266 views1 answer
Sql beginning of previous month
SQL
5 votes281 views4 answers
Change auto increment mysql
SQL
8 votes311 views1 answer
Mysql limit rows
SQL
0 vote297 views1 answer
Time data type in mysql
SQL
1 vote263 views1 answer
How to drop function in sql
SQL
0 vote596 views1 answer
Create pl/sql stored procedure
SQL