/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

4 votes282 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
5 votes249 views2 answers
Ranking functions in sql
SQL
12 votes270 views4 answers
Mysql get date difference in hours
SQL
1 vote275 views1 answer
How to delete data from sql database in android
SQL
10 votes323 views4 answers
Join multiple tables in sql
SQL
2 votes266 views1 answer
Oracle current date without time
SQL
4 votes266 views1 answer
Oracle session date format
SQL
1 vote249 views1 answer
Sql injection
SQL
0 vote259 views1 answer
Set a default value for a column in sqlite
SQL
0 vote251 views1 answer
Ffeathers express mysql application users login
SQL

Share