IF OBJECT_ID('tempdb.dbo.#type') IS NOT NULL DROP TABLE #type

CREATE TABLE #type (

    [type] NVARCHAR(2),

    [desc] NVARCHAR(30)

)

INSERT INTO  #type ([type],[desc]) VALUES

(N'AF',N'聚合函数(CLR)'),

(N'C',N'CHECK 约束'),

(N'D',N'DEFAULT(约束或独立)'),

(N'F',N'FOREIGN KEY 约束'),

(N'PK',N'PRIMARY KEY 约束'),

(N'P',N'SQL 存储过程'),

(N'PC',N'程序集(CLR)存储过程'),

(N'FN',N'SQL 标量函数'),

(N'FS',N'程序集(CLR)标量函数'),

(N'FT',N'程序集(CLR)表值函数'),

(N'R',N'规则(旧式，独立)'),

(N'RF',N'复制筛选过程'),

(N'SN',N'同义词'),

(N'SQ',N'服务队列'),

(N'TA',N'程序集(CLR)DML 触发器'),

(N'TR',N'SQL DML 触发器'),

(N'IF',N'SQL 内联表值函数'),

(N'TF',N'SQL 表值函数'),

(N'U',N'表(用户定义类型)'),

(N'UQ',N'UNIQUE 约束'),

(N'V',N'视图'),

(N'X',N'扩展存储过程'),

(N'IT',N'内部表')

SELECT [type],[desc] FROM #type