Viewing Object Properties

Go Up to Inspecting Database Objects

The Properties tab is available when viewing Table and View database objects. Use the Properties tab of the object inspector to display properties for database objects, including columns, triggers, check constraints, indexes, unique constraints, and referential constraints. The Properties tab has five toolbar buttons for displaying the various object properties:

Object Inspector Toolbar Buttons

Button	Description
Error creating thumbnail: Unable to save thumbnail to destination	Show columns: displays the name, type, collation, character set, default value, and whether or not null values are acceptable for every row in the column. The accelerator key is W+Y+C. For more information on columns, refer to “Defining columns” in the Data Definition Guide.
Error creating thumbnail: Unable to save thumbnail to destination	Show triggers: displays the name and type of each trigger, as well as whether or not it is active. In addition, it displays the SQL trigger statement. The accelerator key is W+Y+T. For more information on triggers, refer to “Working with Triggers” in the Data Definition Guide.
Error creating thumbnail: Unable to save thumbnail to destination	Show check constraints: displays the names of the constraints, whether or not they can be deferred, and if they were initially deferred. In addition, it displays the SQL check constraint statements. The accelerator key is W+Y+H. For more information, refer to “Defining a CHECK constraint” in the Data Definition Guide.
Error creating thumbnail: Unable to save thumbnail to destination	Show indexes: displays the name of the index keys, and whether or not they are unique, descending, or active. The accelerator key is W+Y+R. For more information, refer to “Working with Indexes” in the Data Definition Guide.
Error creating thumbnail: Unable to save thumbnail to destination	Show unique constraints: displays the names of the constraints, whether or not they can be deferred, if they were initially deferred, and the index keys. The accelerator key is W+Y+U.
Error creating thumbnail: Unable to save thumbnail to destination	Show referential constraints: displays the names of the constraints, whether or not they can be deferred, if they were initially deferred, the match options, the update rules, the delete rules, the index, and the reference table. The accelerator key is W+Y+R.