On Mon, 19 Jul 2004, Tsirkin Evgeny wrote:
> But this way i will touch both the schema AND data
> And what i want is to change the schema ONLY.
The use the ALTER TABLE table* ADD COLUMN syntax to alter
the schema for table and its descendants.
In general, SQL_INHERITANCE=false is primarily there
But this way i will touch both the schema AND data
And what i want is to change the schema ONLY.
Thanks
On Sun, 18 Jul 2004, Stephan Szabo wrote:
> On Tue, 13 Jul 2004, evgeny tsurkin wrote:
>
> > Hi All!
> > That probably was already asked thousand times
> > but i did not find an exact answer:
On Tue, 13 Jul 2004, evgeny tsurkin wrote:
> Hi All!
> That probably was already asked thousand times
> but i did not find an exact answer:
> I want to have two tables the second one will have
> all the columns from the first + some extra .The data
> should be complittly separate .I was trying to
I am but that is what actually want : to be able to add a column
to the first table and have the second to be added a coulumns
automatically.The target is realy simple :
i want to simplify management of the schema and thus be able to
manage only parantes - children should be managed aoutomagically
According to your posting below the second table will have all the
columns of the first table plus extra columns. If that is true then why
are you trying to add a column to your first table and not your second
table as well?
On Tue, 2004-07-13 at 06:32, evgeny tsurkin wrote:
> Hi All!
> That prob
Hi All!
That probably was already asked thousand times
but i did not find an exact answer:
I want to have two tables the second one will have
all the columns from the first + some extra .The data
should be complittly separate .I was trying to use
inheritance and setted the SQL_INHERITANCE = fals
