SELECT DISTINCT
TOP (100) PERCENT o.xtype,
CASE o.xtype WHEN 'X' THEN '扩展存储过程'
WHEN 'TR' THEN '触发器'
WHEN 'PK' THEN '主键'
WHEN 'F' THEN '外键'
WHEN 'C' THEN '约束'
WHEN 'V' THEN '视图'
WHEN 'FN' THEN '函数-标量'
WHEN 'IF' THEN '函数-内嵌'
WHEN 'TF' THEN '函数-表值'
ELSE '存储过程'
END AS 类型, o.name AS 对象名, o.crdate AS 创建时间,
o.refdate AS 更改时间, c.text AS 声明语句
FROM sysobjects AS o LEFT OUTER JOIN
syscomments AS c ON o.id = c.id
WHERE (o.xtype IN ('X', 'TR', 'C', 'V', 'F', 'IF', 'TF', 'FN', 'P', 'PK')) AND
(OBJECTPROPERTY(o.id, N'IsMSShipped') = 0)
ORDER BY 类型 DESC
TOP (100) PERCENT o.xtype,
CASE o.xtype WHEN 'X' THEN '扩展存储过程'
WHEN 'TR' THEN '触发器'
WHEN 'PK' THEN '主键'
WHEN 'F' THEN '外键'
WHEN 'C' THEN '约束'
WHEN 'V' THEN '视图'
WHEN 'FN' THEN '函数-标量'
WHEN 'IF' THEN '函数-内嵌'
WHEN 'TF' THEN '函数-表值'
ELSE '存储过程'
END AS 类型, o.name AS 对象名, o.crdate AS 创建时间,
o.refdate AS 更改时间, c.text AS 声明语句
FROM sysobjects AS o LEFT OUTER JOIN
syscomments AS c ON o.id = c.id
WHERE (o.xtype IN ('X', 'TR', 'C', 'V', 'F', 'IF', 'TF', 'FN', 'P', 'PK')) AND
(OBJECTPROPERTY(o.id, N'IsMSShipped') = 0)
ORDER BY 类型 DESC