/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

8 votes298 views1 answer
Oracle add months to sysdate
SQL
0 vote334 views2 answers
How to install psql in ubuntu
SQL
1 vote471 views1 answer
Postgres upgrade to superuser
SQL
-1 vote313 views2 answers
Postgres autoincrement primary key
SQL
0 vote281 views1 answer
Show all mongodb
SQL
21 votes310 views5 answers
Oracle all tables
SQL
0 vote288 views1 answer
Sql counter column
SQL
25 votes368 views5 answers
Mysql replace text
SQL
0 vote288 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
15 votes334 views3 answers
Mysql update add to existing value
SQL

Share