Enforcing data integrity on SQL server database tables

Enforcing data integrity provides guidelines to design table using constraints. While designing a table all the columns data should be taken care.  Using below mechanism we can achieve to enforce the integrity of the data in a column.

• Primary key constraint
• Unique key constraint
• Foreign key constraint
• Check constraints
• Default constraint
• Not null constraints.

Enforcing data integrity ensures the quality of the data in the database.