DROP-SEQUENCE
Prev | Functional Data Definition Language (FDDL) | Next

## Name

DROP-SEQUENCE — Drop a database sequence.Function

## Syntax

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

## Arguments and Values

`name`

  The name of the sequence 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 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

`create-sequence`
`list-sequences`
`sequence-exists-p`
`sequence-last`
`sequence-next`
`set-sequence-position`

## Notes

`drop-sequence` is a CLSQL extension.

Prev | Up | Next
CREATE-SEQUENCE | Home | LIST-SEQUENCES