SELECT TABLES FROM DB

Menu

Use the following

SELECT

TABLE_SCHEMA,

TABLE_NAME, 

OBJECTPROPERTY(object_id(TABLE_NAME), N’IsUserTable’) AS type 

FROM

INFORMATION_SCHEMA.TABLES