IF OBJECT_ID('tempdb..#tempTable') IS NOT NULL
BEGIN
    DROP TABLE #tempTable
END
 
CREATE TABLE #tempTable ([ID] INT NOT NULL,[Type] NVARCHAR(20) NULL,[Category] NVARCHAR(40) NULL)
INSERT INTO #tempTable ([ID],[Type],[Category]) VALUES (1,'TABLE','Table'),
                                                (2,'TABLE','View'),
                                                (3,'SP','Store Procedure'),
                                                (4,'FUN','Table-valued Function'),
                                                (5,'FUN','Scalar-valued Function'),
                                                (6,'TYPE','User-Defined Table Type')
SELECT [ID],[Type],[Category] FROM #tempTable
GO