Versions Compared

Old Version 3

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 4

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

AttributeDefinition
nameRequired. Holds the foreign key constraint name. The name should follow the naming conventions specified in Naming conventions. 
ref-tableRequired for the table name referenced by the foreign key.
ref-columnsRequired. Includes pairs of referencing and referenced columns separated by blanks.
on-delete

Required. Determines what action is taken if one or more rows in the referencing table point to a row in the referenced table that has been deleted. Can have the following values:

  • CASCADE All rows pointing to the deleted row are also deleted. Implementation on all DBMSs: ON DELETE CASCADE
  • NO ACTION The deletion fails. Implementation:
    • ON DELETE NO ACTION for Microsoft SQL Server
    • No ON DELETE clause is specified for Oracle. This is the default.
on-update

Required. Determines what action is taken if one or more rows in the referencing table point to a row in the referenced table that has been updated. Can have the following values:

  • CASCADE All rows pointing to the deleted row are also deleted. Implementation on all DBMSs: ON UPDATE CASCADE
  • NO ACTION The update fails. Implementation:
    • ON UPDATE NO ACTION for Microsoft SQL Server
    • No ON UPDATE clause is specified for Oracle. This is the default.

How to create DDML Documents

Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 | 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 |  
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
  | 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse