/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 vote160 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote167 views1 answer
Drop index in sql
SQL
0 vote169 views2 answers
Mysql password error create datbase
SQL
0 vote168 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote240 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
9 votes178 views4 answers
Oracle get table column names
SQL
0 vote198 views1 answer
Mysql get first 2 characters of string
SQL
6 votes223 views2 answers
How to get last element sql
SQL
1 vote183 views1 answer
Create new index takes long time postgresql
SQL
2 votes188 views2 answers
Install postgresql
SQL

Share