/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 vote274 views1 answer
Sql select first and last record of each group
SQL
0 vote284 views1 answer
Get yesterday date ISO in psql
SQL
3 votes265 views1 answer
Oracle wait
SQL
1 vote315 views1 answer
Mysql last year
SQL
27 votes298 views5 answers
Add column in table
SQL
79 votes532 views6 answers
Grepper code
SQL
0 vote289 views1 answer
Firebird where
SQL
3 votes299 views3 answers
Restart mysql mac
SQL
1 vote289 views2 answers
Sql now - 1 day
SQL
2 votes337 views1 answer
Capitalize 1st letter in sql server
SQL

Share