The
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 *default-database*.
This example creates the view
manager
with the records in the employee table whose department is 50.
(create-view [manager] :as [select [*]
:from [emp]
:where [= [dept] 50]])