SQL获取数据库中表的列名和列类型
时间:2022-03-14 00:24
select column_name as [字段名],data_type as [数据类型]
from information_schema.columns
where table_name=‘表名‘ and data_type<>‘xml‘
时间:2022-03-14 00:24
select column_name as [字段名],data_type as [数据类型]
from information_schema.columns
where table_name=‘表名‘ and data_type<>‘xml‘