/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 vote102 views1 answer
Oracle grant create job
SQL
0 vote96 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote103 views1 answer
Column ' ' in field list is ambiguous
SQL
8 votes92 views1 answer
Ltrim sql
SQL
0 vote115 views1 answer
Sql select inside select sub query
SQL
0 vote108 views1 answer
Sql server pivot rows to columns
SQL
1 vote105 views1 answer
Altering the column name in MySQL to have a default value
SQL
5 votes138 views2 answers
Functions
SQL
0 vote115 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote100 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL

Share