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.
datatype demotes a vendor-specific type. Examples in a MS Access database are :integer, :longchar and :datetime. When datatype is a list, the second element is the length of the type, for example (:varchar 255).
To print the type of every attribute in the database, do
(loop for tab in
(sql:list-tables)
do
(loop for att in
(sql:list-attributes tab)
do
(format t "~&Table ~S Attribute ~S Type ~S"
tab att
(sql:attribute-type att tab))))
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4