1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

Question Posted / rajiv ranjan


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed las..

Answer / Megha Agarwal

The event that will be performed last for an integrity check is a TRIGGER. Triggers are database objects that automatically execute in response to specific events on a table or view, such as an INSERT, UPDATE, or DELETE.nCheck constraints, foreign key constraints, and primary key checks are all enforced when the data modification statement (INSERT, UPDATE, or DELETE) is executed, before the trigger fires.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to stop a loop early with break statements in ms sql server?

1 Answers  

How data can be copied from one table to another table?

1 Answers  

How do I shrink an ldf file?

1 Answers  

How do I find the port number for sql server?

1 Answers  

What are the results of running this script?

1 Answers  

how many layers of tcp/ip protocol combined of? : Sql server database administration

1 Answers  

How can I create a table from another table without copying any values from the old table?

3 Answers  

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

What is data source object?

1 Answers  

Anyone please explain me the concept of Serialization?

3 Answers  

what's the maximum size of a row? : Sql server database administration

1 Answers  

What is @@error in sql?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories