主流数据库获取视图及创建语句汇总
MySQL
select TABLE_NAME,VIEW_DEFINITION
from information_schema.VIEWS where TABLE_SCHEMA = ''
Oracle
select VIEW_NAME ,TEXT from ALL_VIEWS
where OWNER = ''
Postgresql
select TABLE_NAME,VIEW_DEFINITION
from information_schema.VIEWS where TABLE_SCHEMA = ''
达梦
select VIEW_NAME ,TEXT
from ALL_VIEWS where OWNER = ''
SQL Server
select TABLE_NAME, VIEW_DEFINITION
from INFORMATION_SCHEMA.VIEWS where TABLE_SCHEMA = ''
高斯
select TABLE_NAME,VIEW_DEFINITION
from information_schema.VIEWS where TABLE_SCHEMA = ''
DB2
SELECT VIEWNAME ,TEXT
from syscat.views WHERE OWNER = ''
Green Plum
select TABLE_NAME,VIEW_DEFINITION
from information_schema.VIEWS where TABLE_SCHEMA = ''
人大金仓
select TABLE_NAME, VIEW_DEFINITION from INFORMATION_SCHEMA.VIEWS where TABLE_SCHEMA = ''
GBASE8S
SELECT tabname,viewtext
FROM sysviews v, systables t
WHERE v.tabid = t.tabid AND t.tabid >= 100 AND owner =''
GBASE8A
select TABLE_NAME,VIEW_DEFINITION
from information_schema.VIEWS where TABLE_SCHEMA = ''