mysql:
1.查询数据库中所有表名称:
select table_name from information_schema.tables where table_schema=\'数据库名称\';(包含视图)
select table_name from information_schema.tables where table_schema=\'数据库名称\' and table_type = \'BASE TABLE\' AND table_schema = DATABASE ();(不包含视图)
2.查询每张表中所有字段名:
select COLUMN_NAME from INFORMATION_SCHEMA.Columns where table_name=\'表名称\' and table_schema=\'数据库名称\';
oracle:
1.查询数据库中所有表名称:
select t.table_name from user_tables t;
2.查询每张表中所有字段名:
SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = \'表名称\';