SQL Server系统表讲解

1. sysobjects

http://www.cnblogs.com/atree/p/SQL-Server-sysobjects.html

 

2.syscomments

http://www.cnblogs.com/kk1230/archive/2009/12/23/1630757.html

 

3.查询数据库中所有包含某文本的存储过程、视图和函数的SQL

select *

from sysobjects o, syscomments s

where o.id = s.id

and text like'%要查找的文字%'

and o.xtype ='P'

 

4.information_schema对象的使用

http://blog.163.com/freestyle_le/blog/static/1832794482011713103747931/

查询数据库中所有包含某文本的存储过程、视图和函数的SQL

select routine_name,routine_definition,routine_type

from information_schema.routines

where routine_definition like'%Parent%'

orderby routine_type