All Manuals > LispWorks® User Guide and Reference Manual > 45 The SQL Package

table-exists-p Function

Summary

A predicate for the existence of a table.

Package

sql

Signature

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

Arguments
table
A potential table name.
database
A database.
owner
nil, :all or a string.
Values
result
A boolean.
Description

The function table-exists-p determines whether there is a table named table in database database.

If owner is nil, only user-owned tables are considered. This is the default.

If owner is :all, all tables are considered.

If owner is a string, this denotes a username and only tables owned by owner are considered.

The default value of database is *default-database*.

See also

list-tables


LispWorks® User Guide and Reference Manual - 01 Dec 2021 19:30:56