--返回表中字段属性
select SQL_variant_property(字段,'BaseType'),
SQL_variant_property(字段,'Precision'),
SQL_variant_property(字段,'Scale'),
SQL_variant_property(字段,'TotalBytes'),
SQL_variant_property(字段,'Collation'),
SQL_variant_property(字段,'MaxLength')
from 表
select SQL_variant_property(字段,'BaseType'),
SQL_variant_property(字段,'Precision'),
SQL_variant_property(字段,'Scale'),
SQL_variant_property(字段,'TotalBytes'),
SQL_variant_property(字段,'Collation'),
SQL_variant_property(字段,'MaxLength')
from 表
from information_schema.columns
where table_name='表名' and column_name='列名'