SqlServer查询表字段的类型

select * from sys.objects where name='表名' --找出object_id select * from sys.columns where object_id=1218259545 and name='字段名' --找出system_type_id select * from sys.systypes where xtype=35 --查询出是text