> That great and it executed.
> So I don't have a foreign key anymore? Is it not needed? I think that it's part of the available Oracle syntax, so what do I lose by not having it?
You foreign key is still there, you just don't need the "foreign
key" keyword if you define your foreign keys implicitly. You only
need the keyword if you use the full CONSTRAINT syntax, i.e.:
create table fsnep_pollAnswers (
pA_id NUMBER,
pA_pollID NUMBER,
pA_answer NUMBER,
CONSTRAINT constraint_name PRIMARY KEY (pA_id),
CONSTRAINT constraint_name FOREIGN KEY (pA_pollID) REFERENCES
fsnep_polls(p_id)
)
Every database I know off works like that.
> btw, anyone know of a good online Oracle reference or list?
Google:
http://www.google.com/search?q=oracle+foreign+key+create+table
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
