/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 vote186 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
4 votes170 views2 answers
Oracle unlock account
SQL
-1 vote142 views2 answers
Postgresql user permissions to database
SQL
0 vote142 views1 answer
Mysql export and import
SQL
23 votes163 views6 answers
Create table sql server
SQL
0 vote156 views1 answer
How to check default value of column in sql server
SQL
0 vote170 views1 answer
Sql query for login with email or username
SQL
0 vote185 views1 answer
For select oracle
SQL
1 vote150 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote169 views1 answer
Synapse sql table set pk
SQL

Share