MySQL Lists: mysql: Re: Alter Table Add Column

List:	General Discussion	« Previous Message Next Message »
From:	Ow Mun Heng	Date:	October 23 2006 3:48am
Subject:	Re: Alter Table Add Column - How Long to update
View as plain text

On Sun, 2006-10-22 at 21:32 +0800, 黄小聪 wrote:
> "it says this is done so that other read processes can still
> access the DB/table in it's OLD state w/o any hiccups."
> I do not understand

> so how does the MSSQL DB work when we alter table add column 

Frankly, I don't really know. I tried adding a new column to an existing
MSSQL DB and it really just took a few seconds.

>

Thread
• Alter Table Add Column - How Long to update	Ow Mun Heng	20 Oct
• Re: Alter Table Add Column - How Long to update	William R. Mussatto	20 Oct
• Re: Alter Table Add Column - How Long to update	Ow Mun Heng	22 Oct
• Re: Alter Table Add Column - How Long to update	黄小聪	22 Oct
• Re: Alter Table Add Column - How Long to update	Ow Mun Heng	23 Oct