Name

CREATE-VIEW —

Function

Syntax

       (CREATE-VIEW NAME &KEY AS COLUMN-LIST (WITH-CHECK-OPTION NIL) (DATABASE *DEFAULT-DATABASE*)) [function] => 

Arguments and Values

Description

Creates a view called NAME in DATABASE which defaults to *DEFAULT-DATABASE*. The view is created using the query AS and the columns of the view may be specified using the COLUMN-LIST parameter. The WITH-CHECK-OPTION is nil by default but if it has a non-nil value, then all insert/update commands on the view are checked to ensure that the new data satisfy the query AS.

Examples

        
      

Side Effects

Affected by

Exceptional Situations

See Also

Notes

Prev Up Next
TABLE-EXISTS-P Home DROP-VIEW