- NO ACTION specifies that the deletion fails with an error.
- CASCADE specifies that all the rows with foreign keys pointing to the deleted row are also deleted.
- SET NULL specifies that all rows with foreign keys pointing to the deleted row are set to NULL.
- SET DEFAULT specifies that all rows with foreign keys pointing to the deleted row are set to their default value.
What are different actions on ON DELETE clause of foreign key constraint ?
Different actions on ON DELETE clause of foreign key constraint :
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Cache Callback provides an ability where by some actions can be performed when that item is removed from cache CacheItemRemovedCallback ex...
-
XML DOM loads the entire xml document into memory whereas Simple API for XML ( SAX ) does not load entire xml document into memory XML DOM ...
-
Different types of diagrams in UML : UseCase diagram Class diagram Object diagram State diagram Sequence diagram Collaboration diagram...
-
Virtual-Override and New Class Child inherits from Class Parent and has mehtod ShowVirtualOverride() and ShowNew() methods. Please see th...
-
Question : Name few C# 3.0 enhancements ? Answer : The C# 3.0 language enhancements are as follows: Implicitly typed local variables I...
-
If locaction attribute is specified, must be one of: Any, Client, Downstream, None, Server or ServerAndClient.
Posts
No comments:
Post a Comment