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] ... 下一页 >> |
