摘要：--查询存储过程中含某字段的所有存储过程： select distinct name, text from dbo. syscomments a,dbo. sysobjects b where a.id=b.id and b.xtype= 'p' and a. text like '%ZyNum%' 阅读全文

摘要：select name from sysobjects where xtype='u' --读取库中的所有表名 select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name= 阅读全文