/SQL/List all the tables in sql

List all the tables in 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

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

Similar codes

0 vote230 views1 answer
View acl table oracle
SQL
-1 vote223 views1 answer
Sql syntax create timestamp column
SQL
3 votes252 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
3 votes230 views2 answers
Pl sql escape '
SQL
9 votes232 views3 answers
Oracle undo usage by session
SQL
0 vote241 views1 answer
C# execute transact sql
SQL
0 vote246 views1 answer
Query by column for substring sql
SQL
0 vote267 views1 answer
Stratified sampling sql
SQL
0 vote241 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote257 views1 answer
Shrink database file in sql server
SQL

Share