获得某列的数据类型（DataType）等信息

SELECT    

 TABLE_CATALOG AS [Database],

TABLE_SCHEMA AS Owner,

 TABLE_NAME AS TableName,

 COLUMN_NAME AS ColumnName, 

ORDINAL_POSITION AS OrdinalPosition,

COLUMN_DEFAULT AS DefaultSetting,

 IS_NULLABLE AS IsNullable,

 DATA_TYPE AS DataType, 

 CHARACTER_MAXIMUM_LENGTH AS MaxLength,

 DATETIME_PRECISION AS DatePrecision,

COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') as IsIdentity
FROM         INFORMATION_SCHEMA.COLUMNS

 WHERE     (TABLE_NAME = '表名') and COLUMN_NAME='列名'