/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

2 votes159 views1 answer
Sql server find table name
SQL
0 vote184 views1 answer
How to generate ids in sql
SQL
1 vote174 views1 answer
Sql first day quarter
SQL
2 votes180 views1 answer
How to show the whole table in sql
SQL
0 vote132 views1 answer
Mysql find foreign key references
SQL
0 vote280 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
6 votes174 views2 answers
Difference between join vs union
SQL
0 vote191 views1 answer
Sql update subtract value
SQL
1 vote178 views1 answer
Increase existing date in sql oracle
SQL
2 votes169 views1 answer
Date conversion in mysql column
SQL

Share