On Tuesday 18 June 2002 16:19, I wrote:
> Hi,
>
> If I create a table that inherits from another, it inherits all the attributes,
> but does not appear to inherit the constraints, or indexes
>
Just double checked.
It seems that indexes DO get inherited, but I'm not sure about the rest.
(I don't think I had enough rows for the optimizer to kick in indexed searches before)
Regards
JohnT
--
John Taylor J T Response Limited
Director Internet Solutions for Business
+44 (0)1954 261146