LIST-SEQUENCES
Prev | Functional Data Definition Language (FDDL) | Next

## 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.

Prev | Up | Next
DROP-SEQUENCE | Home | SEQUENCE-EXISTS-P