Something like:
create table Employee(
ID int primary key,
Name nvarchar(200)
IDArea int foreign key references Area(ID)
);
go
create table Area(
ID int primary key,
Name nvarchar(200)
);
Does something like this exist in Oracle?
views:
38answers:
2
+2
A:
Yes, just leave out the "GO" keywords and put the statements in a file:
create table Area(
ID int primary key,
Name nvarchar2(200)
);
create table Employee(
ID int primary key,
Name nvarchar2(200),
IDArea int references Area(ID)
);
You must create the Area primary key before the foreign key that references it, so I have swapped these around. Also the foreign key syntax is slightly different in Oracle.
Tony Andrews
2010-06-28 15:04:59
This code would work? I thought foreign keys were different in Oracle from Microsoft SQL.
Sergio Tapia
2010-06-28 15:06:43
The syntax is fine almost - I have just corrected the FK syntax for Oracle in my answer. You need to create the constraints in the parent/child order too - you can't reference Area(ID) before the Area table exists.
Tony Andrews
2010-06-28 15:20:42
Oh, and I changed nvarchar to nvarchar2 to make it work in Oracle. But VARCHAR2 (without the N) is the more usual string datatype in Oracle.
Tony Andrews
2010-06-28 15:26:23
+1. the easiest one perhaps!
Guru
2010-06-28 17:10:56
+1
A:
You should first create the master table, forget nvarchar datatype, and eventually the script would be :
create table Area(
ID number primary key,
Name varchar2(200)
);
create table Employee(
ID number primary key,
Name varchar2(200) ,
IDArea number, constraint fk_idarea foreign key (idarea) references Area(ID)
);
N. Gasparotto
2010-06-28 15:18:08