{Denodo}ビューの変更

https://community.denodo.com/docs/html/browse/8.0/jp/vdp/vql/creating_a_base_view/modifying_a_base_view/modifying_a_base_view
https://community.denodo.com/docs/html/browse/8.0/jp/vdp/vql/defining_a_derived_view/modifying_a_derived_view/modifying_a_derived_view

基本ビューの変更

ALTER TABLE b_tab11 RENAME b_tab1;

ALTER TABLE b_tab1 DESCRIPTION = 'desc of b_tab1';

ALTER TABLE b_tab1 (
  ALTER COLUMN col1 ADD ( DESCRIPTION = 'desc of col1' )
  ALTER COLUMN col2 ADD ( DESCRIPTION = 'desc of col2' )
  ALTER COLUMN col3 ADD ( DESCRIPTION = 'desc of col3' )
);

ALTER TABLE b_tab1 (
  ALTER COLUMN col1 RENAME col1_new
  ALTER COLUMN col2 RENAME col2_new
  ALTER COLUMN col3 RENAME col3_new
);

派生ビューの変更

ALTER VIEW i_tab11 RENAME i_tab1;

ALTER VIEW i_tab1 DESCRIPTION = 'desc of i_tab1';

ALTER VIEW i_tab1 (
  ALTER COLUMN col1 ADD ( DESCRIPTION = 'desc of col1' )
  ALTER COLUMN col2 ADD ( DESCRIPTION = 'desc of col2' )
  ALTER COLUMN col3 ADD ( DESCRIPTION = 'desc of col3' )
);