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

5 votes155 views2 answers
To date oracle
SQL
1 vote167 views1 answer
Oracle user last connection date
SQL
31 votes158 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote153 views1 answer
What is between keyword used for
SQL
14 votes156 views6 answers
Auto_increment mysql
SQL
0 vote145 views1 answer
MySql Modify Increment
SQL
0 vote140 views1 answer
Postgresql stored procedure update table values
SQL
0 vote152 views1 answer
Mysql date time string format for marshmellow field schema
SQL
6 votes211 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote154 views1 answer
Sql select inside select sub query
SQL