/SQL/Select all tables sql

Select all tables sql

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 tables in sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

2

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

List all the tables in sql

select tablespace_name, table_name from all_tables;

0

Source: quora.com

Select all tables sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

0

Source: stackoverflow.com

Similar codes

0 vote244 views1 answer
Get foreign table names mysql
SQL
0 vote195 views1 answer
Sql count * vs count 1
SQL
5 votes203 views2 answers
Sql constraint check value in list
SQL
0 vote194 views1 answer
Bidirectional outer join sql
SQL
0 vote211 views4 answers
What is unique key in sql
SQL
1 vote221 views2 answers
Install sql server management studio ubuntu
SQL
0 vote190 views4 answers
Postgresql between month
SQL
0 vote195 views1 answer
How to connect to mysql in ef 6
SQL
0 vote265 views1 answer
Sintaxis SELECT sql
SQL
0 vote189 views1 answer
Sql list dates between two dates
SQL

Share