/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

6 votes354 views2 answers
Mysql execute file
SQL
0 vote301 views1 answer
Oracle sql date summer time
SQL
12 votes353 views4 answers
How to check mysql version ubuntu
SQL
0 vote317 views2 answers
Cascade syntax in sql
SQL
1 vote346 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote347 views1 answer
The fetch keyword oracle
SQL
13 votes299 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
-2 votes352 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote330 views1 answer
Drop procedure sql
SQL
0 vote357 views1 answer
Min:sec datediff mssql
SQL

Share