5.2 列出表的列

select column_name,data_type,ordinal_position from information_schema.columns where table_schema='SCOTT' and table_name='EMP';

原文地址:https://www.cnblogs.com/liang545621/p/7518761.html