4中基本数据库如何获取当前数据库的表查询

1.mysql

SELECT table_name FROM information_schema.TABLES where table_schema='数据库'

2.db2

SELECT tabname as table_name FROM syscat.tables where tabschema=current schema

3.sqlserver

select name as table_name from sysobjects where xtype='U'

4.oracle

select table_name from user_tables where table_name like 'bcs_log_log_oss_%'"