Chapter 3 DBMS Reference Guide
You can define values for the following common entries for the Reference object in the DBMS definition.
| Entry | Example (Sybase Adaptive Server Anywhere 6) |
|---|---|
| Enable | Enable = Yes |
| Create | Note that the check on commit (CHCKONCMMT) at the end of the example is useful during reverse engineering to parse the text.
Alter table [%QUALIFIER%]%TABLE% Add foreign key %CONSTNAME% (%FKEYCOLUMNS%) references [%PQUALIFIER%]%PARENT% (%CKEYCOLUMNS%) [on update %UPDCONST%] [on delete %DELCONST%] [%CHCKONCMMT% ? check on commit] |
| Add |
foreign key %CONSTNAME% (%FKEYCOLUMNS%) references [%PQUALIFIER%]%PARENT% (%CKEYCOLUMNS%) [on update %UPDCONST%] [on delete %DELCONST%] [%CHCKONCMMT% ? check on commit] |
| Drop |
if exists(select 1 from sys.sysforeignkey where role='%CONSTNAME%') then alter table [%QUALIFIER%]%TABLE% delete foreign key %CONSTNAME% end if |
| SqlAttrQuery | — |
| SqlListQuery | — |
| ModifiableAttributes | List of extended attributes that will be taken into account in the merge dialog box during database synchronization |
| ReversedStatements | List of statements that will be reverse engineered |
For a description of each of the common object entries, see section "Common object entries".
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |