Constraints In Microsoft SQL Server 2000

(Page 1 of 8 )

Database constraints, database integrity, keys and constraints are explained with code and examples thoroughly in this article.  Ensuring data integrity is emphasized as well. Protect your information investment by using these helpful tips and keys!  "Moving the responsibility for data integrity into the database has been revolutionary to database management. Constraints in Microsoft SQL Server 2000 allow us to define the ways in which we can enforce the integrity of a database.  Using constraints is preferred to using triggers, stored procedures, rules, and defaults, as a method of implementing data integrity rules."

---

Moving the responsibility for data integrity into the database has been revolutionary to database management. Constraints in Microsoft SQL Server 2000 allow us to define the ways in which we can automatically enforce the integrity of a database. Constraints define rules regarding permissible values allowed in columns and are the standard mechanism for enforcing integrity. Using constraints is preferred to using triggers, stored procedures, rules, and defaults, as a method of implementing data integrity rules. The query optimizer also uses constraint definitions to build high-performance query execution plans. Today we will be learning about the different types of constraints and their sub classes.  What is the common goal?  Ensuring data integrity!

Next: Types of Constraints >>
 

More Database Code Articles
More By Gayathri Gokul

Comments On: Constraints In Microsoft SQL Server 2000

· The article is well informative. It has placed various attributes with well designed...   >>> Post your comment now!