Oracle:
法一:
select column_name,data_type,data_length from user_tab_columns where table_name='EMP';
法二:
select cname,coltype,width from col where tname='EMP';
法三:
desc EMP;--命令行可以用
SQL Server:
select column_name,data_type from information_schema.columns where table_name = '表名';