Displaying table column properties

To display the table column properties:

Procedure

  1. Select a table in the left pane.
  2. 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 is Not Null. If the column is NOT NULL NOT DROPPABLE, the value displayed is Not 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.