Introduction:
Here I will
explain primary key constraint in sql server, foreign key constraint
in SQL sever, unique key constraint in sql server, not null
constraint in sql server and check constraint in sql server.
Description:
A Constraint is a property that we can assign to column in table. By assigning constraint property on column we can prevent the users to enter inconsistent of data in columns. We can assign these Constraint properties during the time of creation of table (By Using CREATE TABLE statement) or during the time of changing the existing table structure (By Using ALTER TABLE statement).