/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 vote193 views1 answer
Media sql
SQL
-1 vote205 views1 answer
Ssql to lowercqse
SQL
13 votes190 views2 answers
Mysql order by multiple columns
SQL
10 votes200 views5 answers
Mysql create user
SQL
15 votes186 views2 answers
Open postgress in terminal mac
SQL
1 vote195 views3 answers
How to update column name in psql
SQL
0 vote199 views1 answer
Mssql disable foreign key constraint
SQL
0 vote156 views1 answer
Store query result in variable sql
SQL
8 votes193 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote199 views1 answer
How to input data as id in database sql c#
SQL

Share