查询一个表的所有列名,数据类型
select column_name,data_type from information_schema.columns
where table_name = 'Sys_User'
-
information_schema:系统视图
-
sys.extended_properties:系统视图
select column_name,data_type from information_schema.columns
where table_name = 'Sys_User'
information_schema:系统视图
sys.extended_properties:系统视图