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

## Name

CREATE-SEQUENCE — Create a database sequence.Function

## Syntax

          create-sequence name &key 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*.

## Description

Creates a sequence called `name` in `database` which defaults to *default-database*.

## Examples

    (create-sequence [foo])
    =>
    (sequence-exists-p [foo])
    => T

## Side Effects

A sequence is created in `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 a relation called `name` already exists.

## See Also

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

## Notes

`create-sequence` is a CLSQL extension.

Prev | Up | Next
LIST-ATTRIBUTES | Home | DROP-SEQUENCE