LIST-ATTRIBUTES
Prev Functional Data Definition Language (FDDL) Next

Name

LIST-ATTRIBUTES — Returns the attributes of a table as a list.Function

Syntax

      list-attributes name &key owner database => result

Arguments and Values

name

The name of a 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 list.

Description

Returns a list of strings representing the attributes of table name in database which defaults to *default-database*. owner is NIL by default which means that only attributes owned by users are listed. If owner is a string denoting a user name, only attributes owned by owner are listed. If owner is :all then all attributes are listed.

Examples

(list-attributes [employee])
=> ("emplid" "groupid" "first_name" "last_name" "email" "ecompanyid" "managerid"
    "height" "married" "birthday" "bd_utime")

Side Effects

None.

Affected by

*default-database*

Exceptional Situations

None.

See Also

attribute-type
list-attribute-types

Notes

None.

Prev Up Next
LIST-ATTRIBUTE-TYPES Home CREATE-SEQUENCE