这里总结几个数据库的查询所有表的SQL语句:
Mysql database:
show tables
Oracle database:
select table_name from tabs
SQLServer database
SELECT Name FROM Master..SysDatabases
Postgresql database
SELECT TABLEname FROM pg_tables
Hive database
show tables
这里总结几个数据库的查询所有表的SQL语句:
Mysql database:
show tables
Oracle database:
select table_name from tabs
SQLServer database
SELECT Name FROM Master..SysDatabases
Postgresql database
SELECT TABLEname FROM pg_tables
Hive database
show tables