Key

Chapter 3 DBMS Reference Guide

Key

The Key category is located in the Root→Script→Objects category, and can contain the following items that define how keys are modeled for your DBMS.

Item	Description
[Common items]	The following common object items may be defined for keys: Add AfterCreate, AfterDrop, AfterModify BeforeCreate, BeforeDrop, BeforeModify ConstName Create, Drop Enable MaxConstLen ModifiableAttributes Options, DefOptions ReversedQueries, ReversedStatements SqlAttrQuery, SqlListQuery, SqlOptsQuery For a description of each of these common items, see Common object items.
AKeyComment	Specifies a statement for adding an alternate key comment.
AllowNullable Coln	Specifies whether non-mandatory columns are permitted. The following settings are available: Yes - Non mandatory columns are permitted. No - Non mandatory column are not permitted.
EnableCluster	Specifies whether clustered constraints are permitted on alternate keys. Yes - Clustered constraints are permitted. No - Clustered constraints are not permitted.
SqlAkeyIndex	Specifies a reverse-engineering query for obtaining the alternate key indexes of a table by live connection. Example (SQL Anywhere 10): select distinct i.index_name from sys.sysuserperms u join sys.systable t on (t.creator=u.user_id) join sys.sysindex i on (i.table_id=t.table_id) where i."unique" not in ('Y', 'N') [ and t.table_name = %.q:TABLE%] [ and u.user_name = %.q:SCHEMA%]

UniqConstAuto Index	Determines whether a `Create Index` statement is generated for every key statement. The following settings are available: Yes - Automatically generates an alternate key index within the alternate key statement. If you select the alternate key check box under create index when generating or modifying a database, the alternate key check box of the create table will automatically be cleared, and vice versa. No - Alternate key indexes are not automatically generated. Alternate key and create index check boxes can be selected at the same time.