aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Showing posts with label SQL Constraints. Show all posts
Showing posts with label SQL Constraints. Show all posts

Primary key constraint in sql server, foreign key constraint, unique key constraint, not null, check constraint in SQL Server

Jul 10, 2011 20 comments

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.


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).

Other Related Posts

© 2010-2012 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.