如何从数据库中获取视图定义? (DBMR2327)
DBMaster中有两个用于获取视图定义的SQL语句。一个是 “def view view_name”,另一个是“select cast (view_definition as char(n)) from sysviewdata where view_name='view_name'”。
例如:
dmSQL> def view V2;
Create view SYSADM.V2 as select C1 from SYSADM.T1 ;
dmSQL> select cast(view_definition as char(100)) from sysviewdata where view_name='V2';
CAST(VIEW_DEFINITION AS CHAR(100))
============================================================
create view SYSADM.V2 as select C1 from SYSADM.T1
1 rows selected
注意:
如果n值小于视图定义语句的长度,用户就无法获取整个视图定义语句。在这种情况下,用户就需要设置一个较大的n值。
版本: DBMaster4.x/5.x
产品: Normal/Bundle
平台: Windows/Linux