- 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
-
Answer : WCF belongs to System.ServiceModel
-
Different types of assemblies are : Static and Dynamic assemblies Private and Shared assemblies Single file and Multiple file assemblies ...
-
Authorization is used to determine whether user has access to resource or not. There are two ways to authorize a resource : File authoriza...
-
Operation behaviour are scoped at Operation level. It is used for transaction flow , serialization , parameter handling.
-
Different type of method parameters in C# are : Value Parameter Reference Parameter Output Parameter
-
Abstract class has following features : cannot be instantiated contain abstact methods and properties cannot modify abstract class with s...
-
OOPs concepts that C# supports are : Abstraction : is a process that involves identifying the crucial behavior of an object and eliminatin...
-
Characteristics of well designed normalized database are : Table should have identifier Table should store data for single type of entity...
-
There are five types of contracts : Service Contract Operation Contract Data Contract Message Contract Fault Contract Please refer be...
Posts
No comments:
Post a Comment