mysql:
表名:
select table_name from information_schema.tables where table_schema='数据库'
视图名:
select table_name from information_schema.views where table_schema='数据库'
SQLServer:
表名:
select name from sysobjects where xtype='U'
视图名:
select name from sysobjects where xtype='V'
Oracle:
表名:
select TABLE_NAME from all_tables WHERE owner='用户'
视图名:
select VIEW_NAME from all_views WHERE owner='用户'
欢迎关注wx公众号:python web小栈,共同探讨学习