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
	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.
	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.
	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.
	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.
	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.
	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.