Inheritance is not the replacement for foreign keys. Inheritance
mechanism is a sort of "create like" thing. Created table inherits
column names and types. Indexes and constraints are not inherited.
Foreign keys still have to be used to guarantee the logical consistency.
Zdravko Balorda wrote:
>
> Hi,
> I'm new to inheritance. Does anyone have a good link about it?
>
> I have just finished an application using parent and child tables.
> Tables look a bit strange. :)
>
> Inheritance seems a good replacement for foreign keys. One can
> completely forget about them which simplifies programming.
> A great idea, this inheritance.
>
> Regards, Zdravko
>
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions