Displaying details of columns in a table or view (DESCRIBE command)
Use the DESCRIBE command to display information about the columns of the specified table or view.
Syntax
DESCRIBE [database_name.]object_name;
The output for this command includes the column name, the data type (returned as the ObjectServer ID), the length of the column, and whether the column is part of a primary key (1 if it is, 0 if it is not).
Hidden columns are not displayed because they are maintained by the system, and a typical user does not need to view or update them.
Example
Use the following command to display information about the columns in the catalog.tables table:
describe catalog.tables;
Sample output for the preceding command is:
ColumnName Type Size Key
-------------------- --------- --------- ------------
TableName 2 40 1
DatabaseName 2 40 1
Status 0 4 0
NumDependents 12 4 0
TableID 0 4 0
TableKind 0 4 0
StorageKind 0 4 0
ServerID 0 4 0