Oracle:
-- 获取当前用户所有表名称:
select table_name from user_tables order by table_name;
-- 获取GAME_HERO表的所有字段名称(注意表名称一定要大写):
select column_name from user_tab_columns where Table_Name='GAME_HERO' order by column_name;
MySQL:
-- 获取test数据库所有表名称
select table_name from information_schema.tables where table_schema='test' and table_type='base table' order by table_name;
-- 获取test数据库users表的所有字段名称
select column_name from information_schema.columns where table_schema='test' and table_name='users' order by column_name;