Re: foreign key rule error

Thanks Daniel and Vitaliy

Daniel, I appreciate your comments and must admit I'm very confused. My earlier attempts to research the problem took me to C J Date's textbook "An Introduction to Database Systems" (25th Ed.) where I followed the example on page 269. This also confirmed my class notes, however the code wouldn't process. I did finally get the table created by only including one 'referential action' (in this case "on delete cascade") in each foreign key statement.

I'm 3 months into my Information Systems subject and the terms "PCTFREE, PCTUSED, INITIAL, NEXT" are not known to me. Daniel, I would be grateful if you could recommend reference material that expands on your comments about creating tables.

Vitaliy, I must admit I had included the fields in one of my previous attempts. I understood that a referencing field was only required if the foreign key references a candidate key that is NOT a primary key of the parent table. Am I wrong, or do I need to find another lecturer ........ did I mention I was confused?

Thanks again for your responses
Vic

--
Posted via http://dbforums.com