请问有没有办法获取sqlsever中一个数据库里所有存储过程或者函数的名字

use

yourDB;

go

select [name] 

from sysobjects

where xtype in('p','FN')

3.SqlServer数据库字典--主键.外键.约束.视图.函数.存储过程.触发器.sql



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 dbo.sysobjects o LEFT OUTER JOIN 



dbo.syscomments 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 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 DESC