Reg Me Please wrote:
> Hi all.
>
> Is there a way to inherit from a table with the LIKE construct and
> also get its indexes along with contraints, DEFAULTs and NOT NULLs?
CREATE TABLE ... LIKE isn't inheritance, it's copying the structure.
I believe you can duplicate indexes in 8.3.
--
Richard Huxton
Archonet Ltd