Get SQL Database Table Names, Procedures, Table types and Views names

SELECT Name FROM sys.objects WHERE [Type] In ('U') -- For table Names

SELECT Name FROM sys.objects WHERE [Type] In ('V') -- For VIEWS

SELECT Name FROM sys.objects WHERE [Type] In ('PK') -- For PRIMARY_KEY_CONSTRAINT

SELECT Name FROM sys.objects WHERE [Type] In ('TT') -- For TYPE_TABLE

SELECT Name FROM sys.objects WHERE [Type] In ('P') -- SQL_STORED_PROCEDURE