SQL server SQL 语句收集--持续更新

查看表信息：

select COLUMN_NAME from information_schema.columns where table_name='TableName'

-----查看所有存储过程与函数
sel#ect * from dbo.syso#bjects whe#re OBJECTPROPERTY(id, N'IsProcedure') = 1 ord#er by name
-----查看存储过程的内容    
sel#ect text f#rom syscomments wh#ere id=object_id('P_InitiateScheme')

--表
sele#ct na#me f#rom sysob#jects whe#re xtyp#e='U' ord#er b#y name;

--触发器
sel#ect   *   fro#m   sysobj#ects   whe#re   xty#pe='TR'