/SQL/Get the list of all tables in sql server

Get the list of all tables in sql server

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'

13

How to get all table names in sql query

BY LOVE SINGHSELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

5

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'

0

Similar codes

1 vote261 views1 answer
Mysql dump specific tables
SQL
0 vote272 views1 answer
Drop procedure sql
SQL
0 vote299 views2 answers
Insert data mysql with cmd
SQL
0 vote294 views1 answer
"Hello User Name"
SQL
2 votes245 views3 answers
Application.properties spring boot mysql
SQL
0 vote292 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote249 views1 answer
MySql count occurences more than"
SQL
0 vote270 views1 answer
How to get data from 2 database
SQL
0 vote267 views1 answer
Mysql url data type
SQL
37 votes281 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL

Share