/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

1 vote293 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote292 views1 answer
Join first name and last name sql
SQL
2 votes286 views4 answers
Mysql select into new table
SQL
24 votes298 views4 answers
Mysql datetime
SQL
0 vote277 views1 answer
Oracle index hint
SQL
2 votes300 views2 answers
Storing timezones in postgres
SQL
0 vote286 views1 answer
Commit transaction sql
SQL
0 vote371 views1 answer
How to rename a database in tsql
SQL
31 votes298 views4 answers
Mysql grant execute
SQL
0 vote318 views1 answer
Sqlalchemy _in array sqlite
SQL

Share