/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

3 votes146 views1 answer
Sql insert inserted id
SQL
0 vote154 views1 answer
Sql server beginning of month
SQL
0 vote136 views1 answer
Sql clear table
SQL
3 votes134 views1 answer
Select without null values sql
SQL
0 vote135 views1 answer
Sql server inner join convert collation
SQL
-1 vote158 views1 answer
Ms sql select datetime as date
SQL
0 vote103 views2 answers
Postgresql could not start server mac
SQL
0 vote156 views1 answer
Vbscript clean up ADODB.Recordset
SQL
5 votes155 views1 answer
Sql table columns
SQL
1 vote145 views1 answer
Load sql into mamp
SQL

Share