/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 vote219 views1 answer
Psql connect to another database
SQL
0 vote178 views2 answers
Denormalization in sql
SQL
2 votes230 views1 answer
Laravel sql String
SQL
0 vote222 views1 answer
Mysql max number not returning correct value
SQL
0 vote217 views1 answer
How to find top 3 salary in sql
SQL
7 votes260 views2 answers
How to create index mysql
SQL
0 vote219 views1 answer
Query on date sqlite flutter
SQL
0 vote227 views1 answer
Sql server query database space available
SQL
0 vote222 views2 answers
Sqlite
SQL
0 vote223 views1 answer
Sauvegarde complète my sql
SQL

Share