Home » SQL & PL/SQL » SQL & PL/SQL » foreign key constraint referencing rowid
foreign key constraint referencing rowid [message #4358] Mon, 02 December 2002 15:19 Go to next message
PatH
Messages: 1
Registered: December 2002
Junior Member
Can a foreign key constraint be created that references a rowid of another table?

What would the 'alter' statement be?

Report message to a moderator

Re: foreign key constraint referencing rowid [message #4359 is a reply to message #4358] Mon, 02 December 2002 16:21 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
No, a foreign key must reference the primary key or a unique key in the referenced table.

Report message to a moderator

Previous Topic: native dynamic sql or DBMS_SQL package
Next Topic: Cursor in PL/SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 22:23:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.