Filter
Top Products
[Figure: Deleting a column from a table]
Adding a view definition (CREATE VIEW statement)
To add a view definition to a previously defined schema, use a CREATE VIEW statement. A view definition cannot be
altered. To change a view definition, first delete the view definition and then add a new view definition. An example of
adding a view definition follows. For details about how to specify the CREATE VIEW statement, see "2.6 Defining a
Local Structure."
Example:
Add a PHONE_LIST view to the schema named STOCKS.
Deleting a view definition (DROP VIEW statement)
To delete a view definition from a previously defined schema, use the DROP VIEW statement. If a view table to be
deleted is referenced in another view table, a procedure routine, a function routine, or a trigger definition, the view
definition cannot be deleted. Delete the view table, procedure routine, function routine, or trigger definition that
references the view table to be deleted before deleting the view definition. To delete the view table, procedure routine,
function routine, or trigger definition that references a view table together with the view table definition, specify
CASCADE.
An example of deleting a view definition follows.
Example:
Delete the definition of the view named STOCK_VIEW.
Adding a trigger definition (CREATE TRIGGER statement)
To add a trigger definition, use the CREATE TRIGGER statement. For more information on how to specify the
CREATE TRIGGER statement, see 2.6 "Defining a Logical Structure."
Example:
Define the trigger ORDER_TRIGGER.
120