获取某一数据库的所有存储过程的名字

SELECT    name AS spname
FROM    sysobjects
WHERE    xtype = 'p'
ORDER BY name

 

xtype是sysobjects表中的一列, 其中存储的是对象的类型. 从上面的语句可以看出'p'代表的是存储过程, 那么其他的类型呢?

以下是xtype的部分列表.

  • C = CHECK constraint
  • D = Default or DEFAULT constraint
  • F = FOREIGN KEY constraint
  • L = Log
  • P = Stored procedure
  • PK = PRIMARY KEY constraint (type is K)
  • RF = Replication filter stored procedure
  • S = System table
  • TR = Trigger
  • U = User table
  • UQ = UNIQUE constraint (type is K)
  • V = View
  • X = Extended stored procedure
  • FN = Function

资料来源:

Get All the Stored Procedure Names In One Shot

http://www.devx.com/tips/Tip/27129

Use Sysobjects in SQL Server to Find Useful Database Information

http://www.devx.com/tips/Tip/14107

posted on 2010-04-23 07:34  中道学友  阅读(649)  评论(0编辑  收藏  举报

导航

技术追求准确,态度积极向上