/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 vote274 views1 answer
Update foreign key value in mysql
SQL
0 vote276 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote268 views1 answer
Call scalar valued function sql
SQL
0 vote261 views1 answer
Install squirrel sql ubuntu
SQL
0 vote284 views1 answer
Mysql reset wp_options
SQL
0 vote256 views1 answer
Sql server beginning of month
SQL
1 vote260 views1 answer
Importance of comment in mysql
SQL
0 vote238 views1 answer
Oracle sql date summer time
SQL
7 votes266 views1 answer
Oracle pagination query offset
SQL
0 vote276 views1 answer
Vbscript connect mssql
SQL

Share