sp_helptext ‘存储过程名称’–查询存储过程
sp_helpindex ‘表名’–查询索引
select text from syscomments s1 join sysobjects s2 on s1.id=s2.id where name=’视图名称’–查询视图
sp_helptext ‘存储过程名称’–查询存储过程
sp_helpindex ‘表名’–查询索引
select text from syscomments s1 join sysobjects s2 on s1.id=s2.id where name=’视图名称’–查询视图