/SQL/Select all tables sql

Select all tables 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

How to get all tables in sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

2

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

Select all tables sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

0

Source: stackoverflow.com

Similar codes

0 vote198 views1 answer
Get total and distict row diff in sql
SQL
0 vote174 views1 answer
Primary key multiple colums
SQL
1 vote206 views1 answer
Wherein mysql
SQL
0 vote258 views1 answer
Trigger
SQL
2 votes172 views1 answer
Alter table add multiple columns postgresql
SQL
2 votes214 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote169 views1 answer
To change the database owner in SQL server
SQL
0 vote175 views1 answer
How to use query in nosql
SQL
1 vote173 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
1 vote189 views1 answer
Sql select max value from multiple rows
SQL

Share