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