select * from syscolumns where (id = OBJECT_ID('TestTable'))
下面不列出A,B这两个测试字段
name | id | xtype | typestat | xusertype | length | xprec | xscale | colid | xoffset | bitpos | reserved | colstat | cdefault | domain | number | colorder | autoval | offset | collationid | language | status | type | usertype | printfmt | prec | scale | iscomputed | isoutparam | isnullable | collation | tdscollation |
bigint | 149575571 | 127 | 0 | 127 | 8 | 19 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | NULL | -2 | 0 | 0 | 8 | 108 | 0 | NULL | 19 | 0 | 0 | 0 | 1 | NULL | <二进制数据> |
binary(50) | 149575571 | 173 | 2 | 173 | 50 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | NULL | -3 | 0 | 0 | 56 | 37 | 3 | NULL | 50 | NULL | 0 | 0 | 1 | NULL | <二进制数据> |
bit | 149575571 | 104 | 0 | 104 | 1 | 1 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | NULL | 22 | 0 | 0 | 8 | 50 | 16 | NULL | 1 | NULL | 0 | 0 | 1 | NULL | <二进制数据> |
char(10) | 149575571 | 175 | 2 | 175 | 10 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | NULL | -4 | 53284 | 0 | 56 | 39 | 1 | NULL | 10 | NULL | 0 | 0 | 1 | Chinese_PRC_CI_AS | <二进制数据> |
datetime | 149575571 | 61 | 0 | 61 | 8 | 23 | 3 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | NULL | -5 | 0 | 0 | 8 | 111 | 12 | NULL | 23 | 3 | 0 | 0 | 1 | NULL | <二进制数据> |
decimal(18, 6) | 149575571 | 106 | 0 | 106 | 9 | 18 | 6 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | NULL | -6 | 0 | 0 | 8 | 106 | 24 | NULL | 18 | 6 | 0 | 0 | 1 | NULL | <二进制数据> |
float | 149575571 | 62 | 0 | 62 | 8 | 53 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | NULL | -7 | 0 | 0 | 8 | 109 | 8 | NULL | 53 | NULL | 0 | 0 | 1 | NULL | <二进制数据> |
image | 149575571 | 34 | 0 | 34 | 16 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | NULL | -8 | 0 | 0 | 8 | 34 | 20 | NULL | NULL | NULL | 0 | 0 | 1 | NULL | <二进制数据> |
int | 149575571 | 56 | 0 | 56 | 4 | 10 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | NULL | -9 | 0 | 0 | 8 | 38 | 7 | NULL | 10 | 0 | 0 | 0 | 1 | NULL | <二进制数据> |
money | 149575571 | 60 | 0 | 60 | 8 | 19 | 4 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | NULL | -10 | 0 | 0 | 8 | 110 | 11 | NULL | 19 | 4 | 0 | 0 | 1 | NULL | <二进制数据> |
nchar(10) | 149575571 | 239 | 2 | 239 | 20 | 0 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | NULL | -11 | 53284 | 0 | 24 | 39 | 0 | NULL | 10 | NULL | 0 | 0 | 1 | Chinese_PRC_CI_AS | <二进制数据> |
ntext | 149575571 | 99 | 0 | 99 | 16 | 0 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | NULL | -12 | 53284 | 0 | 8 | 35 | 0 | NULL | NULL | NULL | 0 | 0 | 1 | Chinese_PRC_CI_AS | <二进制数据> |
numeric(18, 6) | 149575571 | 108 | 0 | 108 | 9 | 18 | 6 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | NULL | -13 | 0 | 0 | 8 | 108 | 10 | NULL | 18 | 6 | 0 | 0 | 1 | NULL | <二进制数据> |
nvarchar(50) | 149575571 | 231 | 2 | 231 | 100 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | NULL | -14 | 53284 | 0 | 24 | 39 | 0 | NULL | 50 | NULL | 0 | 0 | 1 | Chinese_PRC_CI_AS | <二进制数据> |
real | 149575571 | 59 | 0 | 59 | 4 | 24 | 0 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | NULL | -15 | 0 | 0 | 8 | 109 | 23 | NULL | 24 | NULL | 0 | 0 | 1 | NULL | <二进制数据> |
smalldatetime | 149575571 | 58 | 0 | 58 | 4 | 16 | 0 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | NULL | -16 | 0 | 0 | 8 | 111 | 22 | NULL | 16 | 0 | 0 | 0 | 1 | NULL | <二进制数据> |
smallint | 149575571 | 52 | 0 | 52 | 2 | 5 | 0 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | NULL | -17 | 0 | 0 | 8 | 38 | 6 | NULL | 5 | 0 | 0 | 0 | 1 | NULL | <二进制数据> |
smallmoney | 149575571 | 122 | 0 | 122 | 4 | 10 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | NULL | -18 | 0 | 0 | 8 | 110 | 21 | NULL | 10 | 4 | 0 | 0 | 1 | NULL | <二进制数据> |
sql_variant | 149575571 | 98 | 0 | 98 | 8016 | 0 | 0 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21 | NULL | -19 | 0 | 0 | 8 | 39 | 0 | NULL | 0 | NULL | 0 | 0 | 1 | NULL | <二进制数据> |
text | 149575571 | 35 | 0 | 35 | 16 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | NULL | -20 | 53284 | 0 | 8 | 35 | 19 | NULL | NULL | NULL | 0 | 0 | 1 | Chinese_PRC_CI_AS | <二进制数据> |
timestamp | 149575571 | 189 | 0 | 189 | 8 | 0 | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | NULL | -21 | 0 | 0 | 40 | 37 | 80 | NULL | 8 | NULL | 0 | 0 | 1 | NULL | <二进制数据> |
tinyint | 149575571 | 48 | 0 | 48 | 1 | 3 | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | NULL | -22 | 0 | 0 | 8 | 38 | 5 | NULL | 3 | 0 | 0 | 0 | 1 | NULL | <二进制数据> |
uniqueidentifier | 149575571 | 36 | 0 | 36 | 16 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | NULL | -23 | 0 | 0 | 8 | 37 | 0 | NULL | 0 | NULL | 0 | 0 | 1 | NULL | <二进制数据> |
varbinary(50) | 149575571 | 165 | 2 | 165 | 50 | 0 | 0 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | NULL | -24 | 0 | 0 | 24 | 37 | 4 | NULL | 50 | NULL | 0 | 0 | 1 | NULL | <二进制数据> |
varchar(50) | 149575571 | 167 | 2 | 167 | 50 | 0 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | NULL | -25 | 53284 | 0 | 24 | 39 | 2 | NULL | 50 | NULL | 0 | 0 | 1 | Chinese_PRC_CI_AS | <二进制数据> |
xml | 149575571 | 241 | 0 | 241 | -1 | 0 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28 | NULL | -26 | 0 | 0 | 8 | 0 | 0 | NULL | -1 | NULL | 0 | 0 | 1 | NULL | <二进制数据> |