DESCR

Core command DESC DESCRIBE

Describe the structure of the table

Arguments

<tableName> (mandatory) the name of a table

Examples

DESCR CUSTOMER;

Notes

Describes the structure of a table: DESCR <tableName>, listing each column's name, type, size, nullability and default value.

tableName is mandatory and may be schema-qualified (e.g. DESCR PUBLIC.CUSTOMER). It is looked up case-insensitively: the name is tried as typed, then upper-cased, then lower-cased, and the first variant that resolves to an existing table is used - if that variant isn't the one you typed, the console reports which name was actually matched. There is no wildcard or partial-name support: the (case-insensitive) table name must otherwise match exactly.

Fails with an error if no table name is given, or if none of the three case variants resolves to an existing table.

Last modified in release 5.0.7.