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.