SQL获取数据库中表的列名和列类型时间:2023-03-09 01:04:02 select column_name as [字段名],data_type as [数据类型] from information_schema.columns where table_name='表名' and data_type<>'xml'