Unique Key

Unique Key : – Unique Key does not allow duplicate value but it accept NULL value many times (As every null is unique and never equal to another null).

1) Unique Key (Column Level) :-

a) With System defined name

SQL>create table student(regno number(10) unique, name varchar2(10), dob date, course varchar2(10));

b) With User defined name

SQL>create table student(regno number(10) constraint uk_regno unique,

                     name varchar2(10),dob date,course varchar2(10));

2) Unique Key (Table Level) :-

a) With System defined name

SQL>create table student(regno number(10),name varchar2(10),dob date,course varchar2(10), unique(regno));

b) With User defined name

SQL>create table student(regno number(10),name varchar2(10),dob date,course varchar2(10),constraint uk_regno unique(regno));

3) Composite Unique Key :- Unique Key created for more than one column is called Composite Unique Key.

a) With System defined name

SQL>create table student(regno number(10),name varchar2(10),dob date,course varchar2(10), unique(regno,name));

b) With User defined name

SQL>create table student(regno number(10),name varchar2(10),dob date,course varchar2(10),constraint uk_regno unique(regno,name));                  

--------------------------HAPPY LEARNING -----------------------------

                                                                                                   **THANK YOU**

Primary Key 

Primary Key :- Primary key is a combination of NOT NULL and UNIQUE Key Constraint, Primary key never allow duplicate values and null values in the column.

1) Primary Key (Column Level) :-

a) With System defined name

SQL>create table student(regno number(10) primary key, name varchar2(10),dob date, course varchar2(10));

b) With User defined name

SQL>create table student(regno number(10) constraint pk_regno primary key,name varchar2(10),dob date,course varchar2(10));

2) Primary Key (Table Level) :-

a) With System defined name

SQL>create table student(regno number(10),name varchar2(10),dob date,course varchar2(10), primary key(regno));

b) With User defined name

SQL>create table student(regno number(10),name varchar2(10),dob date,course varchar2(10),constraint pk_regno primary key(regno));

3) Composite Primary Key :- Key, that is created for more that one column is called composite key. If Primary Key is created for more than one column then that Primary Key is called Composite Primary Key.

a) With System defined name

SQL>create table student(regno number(10),name varchar2(10),dob date,course varchar2(10), primary key(regno,name));

b) With User defined name

SQL>create table student(regno number(10),name varchar2(10),dob date,course varchar2(10),constraint pk_regno primary key(regno,name));

                  

--------------------------HAPPY LEARNING -----------------------------

                                                                                                   **THANK YOU**