SQL command to show table

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.

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. 

Try this one.

Use YourDatabaseName
Go

Select * From sys.Tables
Go

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;