e "pdf" version.
>
> I hope I have been of help. - Steve G.
>
>
> -Original Message-
> From: Ulrik Witschass [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 3:33 PM
> To: [EMAIL PROTECTED]
> Subject: Adding a Column to an existing table
>
>
> Hi
At 02:32 PM 3/26/2002, you wrote:
>Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
>
>At the moment, I have to update a large database to be multi-company-ready,
>so I basically have to add a Column "Company_ID" to nearly each table.
>
>What would be the easiest way to do this
downloaded the "pdf" version.
I hope I have been of help. - Steve G.
-Original Message-
From: Ulrik Witschass [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 3:33 PM
To: [EMAIL PROTECTED]
Subject: Adding a Column to an existing table
Hi, I'm new to this list, ho
Run the following for each table:
ALTER TABLE tableName ADD COLUMN Company_ID INT UNSIGNED NULL;
Hope this helps.
Ulrik Witschass wrote:
>Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
>
>At the moment, I have to update a large database to be multi-company-ready,
>so I
PROTECTED]]
Sent: Tuesday, March 26, 2002 3:33 PM
To: [EMAIL PROTECTED]
Subject: Adding a Column to an existing table
Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
At the moment, I have to update a large database to be
multi-company-ready,
so I basically have
Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
At the moment, I have to update a large database to be multi-company-ready,
so I basically have to add a Column "Company_ID" to nearly each table.
What would be the easiest way to do this?
I already thought about running a "SE
