SQL PRIMARY KEY Constraint

The PRIMARY KEY constraint is used to uniquely identifies each record in a database table. The Primary keys in a table contains a unique values. It should contain NULL values. The Table contain a primary key and each table have only primary key.

Understand with Example

The Tutorial illustrate an example to understand SQL PRIMARY KEY Constraint. In this example, we create a table 'Stu_Class_10.The create  statement is used to create a table 'Stu_Class_10'.The following SQL creates a PRIMARY KEY on the "Stu_Id" when the" Stu_Class_10" table is created.

Create Table Stu_Class_10

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

Insert data into Stu_Class_10

The insert into statement is used to add the records or rows to the table '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 PRIMARY KEY Constraint:
c,  database,  ide,  table,  data,  null,  sed,  const,  unique,  key,  value,  int,  id,  ai,  keys,  tab,  if,  ie,  record,  constraint,  values,  to,  contains,  base,  each,  ld,  sh,  e,  primary,  it,  use,  ul,  im,  in,  as,  m,  nt,  tr,  es,  ase,  uniq,  s,  at,  k,  is,  ha,  ll,  ea,  and,  ar,  cons,  strain,  str,  va,  s,  s,  ri,  rd,  th,  sho,  av,  st,  ab,  abl,  alu,  ident,  ident,  pr,  nd,  only,  on,  o,  nl

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 PRIMARY KEY Constraint   View All Comments

Post your Comment

Your Name (*) :

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