Name

DROP-VIEW — Drops a database view.Function

Syntax

      drop-view name &key if-does-not-exist database => 

Arguments and Values

name

The name of the view as a string, symbol or SQL expression.

database

A database object which defaults to *default-database*.

if-does-not-exist

A symbol. Meaningful values are :ignore or :error (the default).

Description

Drops the view called name from database which defaults to *default-database*. If the view does not exist and if-does-not-exist is :ignore then drop-view returns NIL whereas an error is signalled if if-does-not-exist is :error.

Examples

(view-exists-p [foo])
=> T
(drop-view [foo] :if-does-not-exist :ignore)
=> 
(view-exists-p [foo])
=> NIL        
      

Side Effects

A view is dropped database.

Affected by

*default-database*

Exceptional Situations

An error is signalled if name is not a string, symbol or SQL expression. An error of type sql-database-data-error is signalled if name doesn't exist and if-does-not-exist has a value of :error.

See Also

create-view
list-views
view-exists-p

Notes

The if-does-not-exist keyword argument to drop-view is a CLSQL extension.