Creates a view using a specified query.
create-view name &key as column-list with-check-option database =>
The view to be created.
An SQL query statement.
create-view function creates a view called name using the as query and the optional column-list and with-check-option . The column-list argument is a list of columns to add to the view. The with-check-option adds
WITH CHECK OPTION to the resulting SQL.
The default value of with-check-option is
nil . The default value of database is
This example creates the view
manager with the records in the employee table whose department is 50.
(create-view [manager] :as [select [*]
:where [= [dept] 50]])
LispWorks Reference Manual (Windows version) - 14 Dec 2001