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