/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

2 votes167 views1 answer
Wait delay in sql server
SQL
3 votes170 views1 answer
Oracle list user grants
SQL
1 vote131 views2 answers
Last working day in week date function in sql
SQL
0 vote169 views2 answers
Mysql on update current_timestamp
SQL
2 votes190 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote233 views1 answer
Php insert null mysql
SQL
0 vote176 views1 answer
Oracle webcenter content search enginer
SQL
0 vote212 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
1 vote176 views1 answer
Postgres concat_ws
SQL
0 vote177 views1 answer
MySQL - Enabling the Event Scheduler
SQL

Share