/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 vote196 views1 answer
Resulting Query
SQL
11 votes205 views2 answers
Having in sql
SQL
0 vote231 views1 answer
Oracle db timestamp auto add
SQL
1 vote204 views2 answers
Populate sql table with random data
SQL
3 votes253 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
2 votes246 views1 answer
Username sql
SQL
0 vote213 views1 answer
Query only first letter string
SQL
13 votes287 views3 answers
Sql select from multiple tables without join
SQL
1 vote217 views1 answer
Psql connect to another database
SQL
4 votes274 views1 answer
Postgresql list sequences
SQL

Share