Difference between Check Constraint and Rule?

 Posted by Sriramnandha on 6/3/2012 | Category: Sql Server Interview questions | Views: 3026 | Points: 40

The major difference between rule and Check is re usability. Check constraint is associated with columns in a Table. So these can't be re-used. Rules are defined with in a database and can be applied to any number of columns.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response