Chapter 3 DBMS Reference Guide
You can define values for the following common entries for the Pkey object in the DBMS definition.
| Entry | Example (Sybase Adaptive Server Enterprise 11) |
|---|---|
| Enable | Enable = Yes |
| Create |
[%USE_SP_PKEY%?[execute] sp_primarykey %TABLE%, %PKEYCOLUMNS% :alter table [%QUALIFIER%]%TABLE% add [constraint %CONSTNAME%] primary key [%CLUSTER% ](%PKEYCOLUMNS%) [%OPTIONS%]] |
| Add |
[constraint %CONSTNAME%] primary key [%CLUSTER% ](%PKEYCOLUMNS%) [%OPTIONS%] |
| Drop |
[%USE_SP_PKEY%?execute sp_dropkey primary, %TABLE% :alter table [%QUALIFIER%]%TABLE% drop constraint %CONSTNAME%] |
| Options |
<clustered> %s : list=clustered | nonclustered
with : composite=yes, separator=yes, parenthesis=no
{
fillfactor=%d : default=0
max_rows_per_page=%d : default=0
}
on %s : category=storage
|
| DefOptions | — |
For a description of each of the common object entries, see section "Common object entries".
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |