/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

17 votes207 views5 answers
Order by sql
SQL
1 vote204 views1 answer
Increase date by one day in sql oracle
SQL
2 votes250 views3 answers
How to replace null values in sql
SQL
22 votes262 views4 answers
Mysql format date
SQL
2 votes217 views2 answers
Postgres add column integer
SQL
32 votes221 views6 answers
Insert select
SQL
0 vote205 views1 answer
How to check the port of mysql installation in mac
SQL
4 votes234 views2 answers
Postgresql float data type
SQL
0 vote194 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote197 views1 answer
Sql select inside select sub query
SQL

Share