Displaying table column properties
To display the table column properties:
Procedure
- Select a table in the left pane.
-
In the right pane, click
Columns.
The following details appear:
-
Primary Key—An icon or key symbol to indicate that the column is part of the primary key. If the column is not a part of the primary key, the field is blank.
-
Column Name—The name of the column (string).
-
Data Type—The SQL data type of the column.
-
Nullable—If the column is
NOT NULL DROPPABLE
, the value displayed isNot Null
. If the column isNOT NULL NOT DROPPABLE
, the value displayed isNot Null Not Droppable
-
Default—A constant which is used when a row is inserted in the table without a value for the column.
-
Heading—The string is displayed at the top of the column values when a
select
statement is executed on the table.
-