SQL Server constraints - August 29, 2008 at 18:00 PM by Nishant Kumar
What are constraints in SQL Server?
Constraints enforce the data integrity to the database and protect columns of
the table from unwanted values. NOT NULL, CHECK, UNIQUE, PRIMARY KEY, FOREIGN
KEY are the types of contraints define in SQL Server.
Define default constraint?
Default constraint is used to fill column with default value defined during
creation of table if nothing is supplied while inserting data. IDENTITY columns
and timestamp columns can't be associated with default constraint.
|