sql server查询某个字段的类型

表名:签入合同登记,字段名:F_PAEZ_Price

select b.name as tablename,a.name as columnname,c.name as typename,a.max_length as typelength

from sys.columns a inner join sys.tables b on b.object_id=a.object_id

inner join sys.types c on c.system_type_id=a.system_type_id

where b.name='签入合同登记' and a.name='F_PAEZ_Price'

order by b.name,a.column_id

原文地址:https://www.cnblogs.com/woshinige/p/13984630.html