Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training

SQL UNIQUE Constraint

The UNIQUE constraint uniquely identifies each record in a database table.

Ads

SQL UNIQUE Constraint

     

The UNIQUE constraint uniquely identifies each record in a database table.

 

 

 

 

 

Create Table Stu_Class_10

create table Stu_Class_10(
Stu_Id integer(2) NOT NULL,
Stu_Name varchar(15),
Stu_Class  varchar(10),
UNIQUE (id))

Insert data into Stu_Class_10

insert into Stu_Class_10 values(1,'Komal',10);
insert into Stu_Class_10 values(2,'Ajay',10);
insert into Stu_Class_10 values(3,'Rakesh',10);
insert into Stu_Class_10 values(4,'Bhanu',10);
insert into Stu_Class_10 values(5,'Santosh',10);

Stu_Class_10

Stu_Id Stu_Name Stu_Class
1 Komal 10
2 Ajay 10
3 Rakesh 10
4 Bhanu 10
5 Santosh 10

Advertisements

Share on Google+Share on Google+

SQL UNIQUE Constraint

Posted on: December 20, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: SQL UNIQUE Constraint  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads