Syntax

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

Arguments and Values

Description

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

Examples

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

Side Effects

A sequence is dropped from 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

drop-sequence is a CLSQL extension.