SEQUENCE-EXISTS-P

SEQUENCE-EXISTS-P
Prev	Functional Data Definition Language (FDDL)	Next

Name

SEQUENCE-EXISTS-P — Tests for the existence of a database sequence.Function

Syntax

      sequence-exists-p name &key owner database => result

Arguments and Values

name: The name of the sequence as a string, symbol or SQL expression.
owner: A string, NIL or :all.
database: A database object which defaults to *default-database*.
result: A Boolean.

Description

Tests for the existence of an SQL sequence called name in database which defaults to *default-database*. owner is NIL by default which means that only sequences owned by users are examined. If owner is a string denoting a user name, only sequences owned by owner are examined. If owner is :all then all sequences are examined.

Examples

(sequence-exists-p [foo])
=> NIL

Side Effects

None.

Affected by

*default-database*

Exceptional Situations