Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (55.6k points)

Can anyone tell me how to see all tables in SQL?

1 Answer

0 votes
by (119k points)

Here is the query to see all the tables of current connected database

SELECT * FROM information_schema.tables;

The following query can be used to show only tables from a particular database

SELECT TableName

FROM <Database_NAME>.INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'BASE TABLE'

In case you are interested in SQL, then sign up for this SQL training course by Intellipaat that provides self-paced videos, instructor-led training, and also certification along with hands-on experience.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Aug 16, 2020 in SQL by Sudhir_1997 (55.6k points)
0 votes
1 answer

Browse Categories

...