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

NextPrevUpTopContentsIndex

list-tables

Function
Summary

Returns a list of the table names in a database.

Package

sql

Signature

list-tables &key database owner => table-list

Arguments

database

A database.

owner

nil, :all or a string.

Values

table-list

A list of table names.

Description

The function list-tables returns the list of table names in database, which has a default value of *default-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.

See also

create-table
drop-table
list-attributes
table-exists-p


LispWorks User Guide and Reference Manual - 20 Sep 2017

NextPrevUpTopContentsIndex