/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 vote176 views1 answer
Dnsmasq.conf location macos
SQL
3 votes173 views1 answer
Postgres update column with value from another table
SQL
-1 vote175 views1 answer
Mysql coalesce
SQL
0 vote227 views1 answer
Pl sql join 3 tables
SQL
1 vote187 views1 answer
Base64 encode sql server
SQL
0 vote186 views2 answers
Select index table oracle
SQL
0 vote186 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
-1 vote152 views1 answer
Mysql if example
SQL
0 vote196 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote157 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL

Share