/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

0 vote184 views1 answer
Oracle current session details
SQL
0 vote194 views1 answer
How to query all tables mysql at the same time
SQL
0 vote248 views1 answer
Convert rows into columns in oracle
SQL
0 vote219 views1 answer
How to make sure two tables have same exact data in sql
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote204 views1 answer
Intellij mysql set timezone
SQL
0 vote189 views1 answer
Drop CHECK constraint sql
SQL
0 vote185 views1 answer
Odd record sql query
SQL
10 votes181 views4 answers
Primary key in sql
SQL
0 vote225 views1 answer
Take sql dump in to file
SQL

Share