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;