Online Documentation for SQL Manager for DB2

Options


The Options section of the Create View from Table dialog allows you to specify common options for the view being created.

 

Tables - Create View from Table - Options

 

 

Triggers

Select trigger type(s) to be created for the view with the help of the corresponding flags:

CheckBox Before Insert

CheckBox Before Update

CheckBox Before Delete

 

CheckBox Grant privileges on view according to the privileges on the table

If you check this option then all privileges that were granted to the table will be granted on the view created.