SQL statement for getting all tables name

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.

Hi Abhi,

USE YourDBName
GO
SELECT *
FROM sys.Tables
GO

Thanks