Query To get all the tables in Database

SELECT *
FROM sys.objects
WHERE type = 'u'

-------------------------------
Where 'u' stands for USER_TABLE
Where 'P' stands for SQL_STORED_PROCEDURE
Where 'TR' stands for SQL_TRIGGER



-------------------------------