Q. What is a constraint in SQL Server?
A. A constraint is an object that exists only within confines of a table. Constraints are much like they sound, i.e. - Rules which are enforced on data being entered, and prevents the users from entering invalid data into tables are called constraints. Thus, constraints super control data being entered in tables for permanent storage.