Jun Yang wrote:
> Hi all,
>
> I want to add some common columns to all of my tables. One way I
> think would be to add a super table that contains the common columns
> to all tables. But is there a way to add a super table to existing
> tables for them to inherit from?
>
> Thanks!
>
> Jun
>
as long as the parent and child has the same table struct, yes.
use:
alter table child inherit newparent;
-Andy