摘要:
1. SqlServer数据库字典--表结构.sql SELECT TOP 100 PERCENT --a.id, CASE WHEN a.colorder = 1 THEN d.name ELSE '' END AS 表名, CASE WHEN a.colorder = 1 THEN isnull(f.value, '') ELSE '' END AS 表说明, a.colorder AS 字段序号, a.name AS 字段名, CASE WHEN COLUMNPROPERTY(a.id, a.name, 'IsIdentity 阅读全文
摘要:
sysobjects 有过程名SYSCOLUMNS中有参数syscomments 有全部语法select c.text,o.name from syscomments c,sysobjects o where o.id=c.id and o.xtype in ('P','V') 阅读全文