Precision'''') As 长度,
50
51 Isnull(Columnproperty(A.Id,A.Name,''''Scale''''),0) As 小数位数,
52
53 (Case When A.Isnullable=1 Then ''''√''''Else '''''''' End) 允许空,
54
55 Isnull(E.Text,'''''''') 默认值,
56
57 Isnull(G.[Value],'''''''') As 字段说明
58
59From Syscolumns A Left Join Systypes B
60
61On A.Xtype=B.Xusertype
62
63Inner Join Sysobjects D
64
65On A.Id=D.Id And D.Xtype=''''U'''' And D.Name<>''''Dtproperties''''
66
67Left Join Syscomments E
68
69On A.Cdefault=E.Id
70
71Left Join Sysproperties G
72上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
