Function

Summary

Returns the type of a table's attribute.

Package

sql

Signature

attribute-type attribute table &key database owner => datatype

Arguments

table

A table.

attribute

An attribute from table .

database

A database.

owner

nil , :all or a string.

Values

datatype

A type.

Description

The function attribute-type returns the type of the attribute specified by attribute in the table given by table . The database, in which table is found, has a default value of *default-database* .

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

If owner is :all , all attributes are considered.

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

Example

This example shows how to query the type of the name attribute of the employee table.

(attribute-type [ename] [emp]) => ("CHAR")

See also

list-attributes