mssql,mysql,oracle中查询数据库表的比较

mysql:

select * from information_schema.tables where table_type='BASE TABLE'

mssql(sqlserver):

select * from ReportServer.information_schema.tables (where table_type='BASE TABLE')

select * from sysobjects where xtype='u'

oracle:

select * from user_tables;

转载于:https://blog.51cto.com/schenjiannan/1340521