SQL Forgein Key Constraints

Google Advertisements

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.

Syntax

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

Example

	
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

Google Advertisements

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

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

Download Projects

Google Advertisements


Buy Websites 9999595223

Buy Fresh and Payment Receive Media.net Account with Website. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs