SQL2008数据库结构查询SQL
摘要：
SELECT TOP 100 PERCENT a.id,CASE WHEN a.colorder = 1 THEN d.name ELSE '' END AS 表名,a.colorder AS 字段序号, a.name AS 字段名,CASE WHEN COLUMNPROPERTY(a.id,a.name, 'IsIdentity') = 1 THEN '√' ELSE '' END AS 标识,CASE WHEN EXISTS(SELECT 1FROM dbo.sysindexes si INNER JOIN dbo.sysin 阅读全文
posted @ 2011-06-09 16:20 风灵溪清 阅读(98) 评论(0) 推荐(0) 编辑
