# Describe

#### Syntax

    DESCRIBE { table-Name | view-Name }

#### Description

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.

#### Example

    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

Parent topic: ij commands and errors reference
Related concepts
ij commands
ij errors
Related reference
Absolute
After Last
Async
Autocommit
Before First
Close
Commit
Connect
Disconnect
Driver
Elapsedtime
Execute
Exit
First
Get Cursor
Get Scroll Insensitive Cursor
Help
Last
LocalizedDisplay
MaximumDisplayWidth
Next
Prepare
Previous
Protocol
Readonly
Relative
Remove
Rollback
Run
Set Connection
Show
Wait For
Comment
Identifier
String