1-- ====================================================== 2 3--列出SQL SERVER 所有表,字段名,主键,类型,长度,小数位数等信息 4 5--在查询分析器里运行即可,可以生成一个表,导出到EXCEL中 6 7-- ====================================================== 8 9Select 10 11 (Case When A.Colorder=1 Then D.Name Else '''''''' End)表名, 12 13 A.Colorder 字段序号, 14 15 A.Name 字段名, 16 17 (Case When Columnproperty( A.Id,A.Name,''''Isidentity'''')=1 Then ''''√''''Else '''''''' End) 标识, 18 19 (Case When (Select Count(*) 20 21 From Sysobjects 22 23 Where (Name In 24 25 (Select Name 26[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |