/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 vote363 views1 answer
Template MySQL Zabbix agent
SQL
1 vote362 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
3 votes352 views2 answers
Mysql user permission database
SQL
3 votes358 views2 answers
Postgres inner join vs join
SQL
0 vote327 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote376 views1 answer
Sql query use select name inside where clause
SQL
0 vote352 views1 answer
Starting mysql shell lampp ubuntu
SQL
11 votes352 views5 answers
Sql server reset identity
SQL
0 vote357 views1 answer
Rabbitmq ui not working
SQL
1 vote344 views1 answer
Mysql sort by date column
SQL

Share