SQL command to show table

Question

Hi, What is the SQL command to show all table of a DataBase? Thanks, in advance.

Jignesh Trivedi · Answer

Hi, all above post is correct, I want add one more talbe from you get information about table, sp, system table ect.. select * from sys.all_objects where type_desc = 'USER_TABLE' hope this help.

Vikrant Jadhav · Answer

hi, select * from SampleDB. sys.tables ; Above Query returns the all tables name from database named SampleDB . Thanks & Regards Vikrant Jadhav Please mark as Correct answer if above post is helpful to you.

Prabhu Raja · Answer

Try this one. Use YourDatabaseName Go Select * From sys.Tables Go

Datta Kharad · Answer

Hi If you do not have access to DBA_TABLES, you can see all the tables that your account has access to through the ALL_TABLES view SELECT owner, table_name FROM all_tables if you are only concerned with the tables that you own, not those that you have access to, you could use USER_TABLES SELECT table_name FROM user_tables OR SELECT * FROM tab; For SQL Server select * from information_schema.tables;

SQL command to show table

Answers (4)