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). When no schema is given, only the connection's current schema is searched, and only that schema's columns are listed; a table with the same name in another schema is not shown. Qualify the name (e.g. DESCR OTHERSCHEMA.TOTO) to describe a table in a different schema. 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.