Describe command

The Describe command 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.

If the table or view is in a particular schema, qualify it with the schema name. If the table or view name is case-sensitive, enclose it in single quotes. You can display all the columns from all the tables and views in a single schema in a single display by using the wildcard character '*'. See the examples below.


DESCRIBE { table-Name | view-Name }


ij> describe airlines;
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
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
-- describe a table in another schema:
ij> describe;
-- describe a table whose name is in mixed-case:
ij> describe 'EmployeeTable';
-- describe a table in a different schema, with a case-sensitive name:
ij> describe 'MyUser.Orders';
-- describe all columns from all tables and views in the APP schema:
ij> describe 'APP.*';
-- describe all columns in the current schema:
ij> describe '*';
Related concepts
ij commands
ij errors
Related reference
Absolute command
After Last command
Async command
Autocommit command
Before First command
Close command
Commit command
Connect command
Disconnect command
Driver command
Elapsedtime command
Execute command
Exit command
First command
Get Cursor command
Get Scroll Insensitive Cursor command
Help command
HoldForConnection command
Last command
LocalizedDisplay command
MaximumDisplayWidth command
Next command
NoHoldForConnection command
Prepare command
Previous command
Protocol command
Readonly command
Relative command
Remove command
Rollback command
Run command
Set Connection command
Show command
Wait For command
Syntax for comments in ij commands
Syntax for identifiers in ij commands
Syntax for strings in ij commands