Name

LIST-SEQUENCES — Returns a list of database sequences.Function

Syntax

      list-sequences &key owner database => result

Arguments and Values

owner

A string, NIL or :all.

database

A database object which defaults to *default-database*.

result

A list of strings.

Description

Returns a list of strings representing sequence names in database which defaults to *default-database*. owner is NIL by default which means that only sequences owned by users are listed. If owner is a string denoting a user name, only sequences owned by owner are listed. If owner is :all then all sequences are listed.

Examples

(list-sequences)
=> ("foo")  
      

Side Effects

None.

Affected by

*default-database*

Exceptional Situations

None.

See Also

create-sequence
drop-sequence
sequence-exists-p
sequence-last
sequence-next
set-sequence-position

Notes

list-sequences is a CLSQL extension.