Syntax

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

Arguments and Values

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

Notes

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