The function create-view 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]])
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4