DESCRIBE { table-Name | view-Name }
Provides a decription of the specified table or view. For a list of tables in the current schema, use the Show Tables command. For a list of views in the current schema, use the Show Views command. For a list of available schemas, use the Show Schemas command.
ij> describe airlines; COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& ------------------------------------------------------------------------------ AIRLINE |CHAR |NULL|NULL|2 |NULL |4 |NO AIRLINE_FULL |VARCHAR |NULL|NULL|24 |NULL |48 |YES BASIC_RATE |DOUBLE |NULL|2 |52 |NULL |NULL |YES DISTANCE_DISCOUNT |DOUBLE |NULL|2 |52 |NULL |NULL |YES BUSINESS_LEVEL_FACT&|DOUBLE |NULL|2 |52 |NULL |NULL |YES FIRSTCLASS_LEVEL_FA&|DOUBLE |NULL|2 |52 |NULL |NULL |YES ECONOMY_SEATS |INTEGER |0 |10 |10 |NULL |NULL |YES BUSINESS_SEATS |INTEGER |0 |10 |10 |NULL |NULL |YES FIRSTCLASS_SEATS |INTEGER |0 |10 |10 |NULL |NULL |YES