select t.name from sysobjects o,syscolumns c,systypes t where o.id=c.id and c.usertype=t.usertype and o.name='your tablename' and c.name='your columnname'
谢谢各位高手!但我还有一个问题,如果一个字段的类型是varchar型,那我该怎么知道它的长度呢??
select COLUMN_NAME,DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = tbName and COLUMN_NAME = fldName其中CHARACTER_MAXIMUM_LENGTH为以字符为单位的最大长度 CHARACTER_OCTET_LENGTH为以字节为单位的最大长度
where o.id=c.id
and c.usertype=t.usertype
and o.name='your tablename'
and c.name='your columnname'
CHARACTER_OCTET_LENGTH为以字节为单位的最大长度