SQL Forgein Key Constraints


Prev Tutorial Next Tutorial

SQL Foreign Key Constraints

Using Foreign Key Constraints you can maintain some relation between the two table in the database.

A Foreign Key is a column whose value are derived from the primary key or unique key or some other table.


create table table_name
(col1 datatype(size) constraints type),
col2 datatype(size),
coln datatype(size));


create table employee
(eid number(3) unique,
ename varchar2(15),
sal number(5));

Note: If you avoid the unique constraints property then it gives the following error messages "unique constraints scott sys-avoided"

Prev Tutorial Next Tutorial


Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

For Projects 9999595223

Google Advertisements

Buy Websites 9999595223
wifi cctv camera

Wifi CCTV Camera RS:1200 to 2499. Contact no. 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs