select column_name as [字段名],data_type as [数据类型]
from information_schema.columns
where table_name='表名' and data_type<>'xml'
转载于:https://www.cnblogs.com/czg10047/p/3998453.html
select column_name as [字段名],data_type as [数据类型]
from information_schema.columns
where table_name='表名' and data_type<>'xml'
转载于:https://www.cnblogs.com/czg10047/p/3998453.html