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

Related Tags for SQL UNIQUE Constraint:
c,  database,  ide,  table,  data,  const,  unique,  int,  id,  ai,  tab,  if,  ie,  record,  constraint,  base,  each,  e,  in,  as,  nt,  tr,  es,  ase,  uniq,  s,  at,  ea,  cons,  strain,  str,  s,  s,  rd,  th,  st,  ab,  abl,  ident,  ident,  on,  o

More Tutorials from this section

• SQL Example, Codes and Tutorials
• Aggregate Functions
• Backup File With Separator
• Backup Into txt File
• Backup selected records into txt file
• Call Procedure
• Close Cursors in SQL
• Create After Insert Trigger in SQL
• Create Before Insert Trigger in SQL
• Create Before Update Trigger in SQL
• Create Delete Trigger in SQL
• Create a Simple Procedure
• Create After Update Trigger in SQL
• Create a database
• Creating Cursors in SQL
• The Normal Forms
• Database Normalization
• Second Normal Form (2NF)
• Third Normal Form (1NF)
• Data Normalization

Ask Questions?    Discuss: SQL UNIQUE Constraint  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):