SQL statement for getting all tables name

Question

Hi What is SQL statement for getting all database table name from Database? Thanks in advance.

Jignesh Trivedi · Answer

hi select * from sys.objects where type='U' and type_desc='USER_TABLE' using type description use can also fine view sp ect in sql use type-Desc SYSTEM_TABLE VIEW SQL_TABLE_VALUED_FUNCTION DEFAULT_CONSTRAINT SQL_STORED_PROCEDURE FOREIGN_KEY_CONSTRAINT SERVICE_QUEUE SQL_INLINE_TABLE_VALUED_FUNCTION USER_TABLE PRIMARY_KEY_CONSTRAINT INTERNAL_TABLE TYPE_TABLE SQL_TRIGGER SQL_SCALAR_FUNCTION UNIQUE_CONSTRAINT hope this help.

Satyapriya Nayak · Answer

Hi Abhi USE YourDBName GO SELECT * FROM sys.Tables GO Thanks