Name

TABLE-EXISTS-P — Tests for the existence of a database table.Function

Syntax

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

Arguments and Values

name

The name of the table 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 table called name in database which defaults to *default-database*. owner is NIL by default which means that only tables owned by users are examined. If owner is a string denoting a user name, only tables owned by owner are examined. If owner is :all then all tables are examined.

Examples

(table-exists-p [foo])
=> T
      

Side Effects

None.

Affected by

*default-database*

Exceptional Situations

None.

See Also

create-table
drop-table
list-tables

Notes

None.