By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Procedure for adding a column

P: n/a
I need to add a column to a table. This table holds several thousand
records, has several indexes, and serves as the parent table to a few
child tables.

When I've done this in the past, it has taken quite a long time for
the ALTER TABLE command to complete.

So, what is the correct procedure for adding a column? Drop the
indexes, add the column, and recreate the indexes?

Thanks.
-David
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, 2003-10-09 at 11:05, David Shadovitz wrote:
I need to add a column to a table. This table holds several thousand
records, has several indexes, and serves as the parent table to a few
child tables.

When I've done this in the past, it has taken quite a long time for
the ALTER TABLE command to complete.

So, what is the correct procedure for adding a column? Drop the
indexes, add the column, and recreate the indexes?


Can you be more explicit about "quite a long time".

--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA

"Whatever may be the moral ambiguities of the so-called demoratic
nations and however serious may be their failure to conform
perfectly to their democratic ideals, it is sheer moral
perversity to equate the inconsistencies of a democratic
civilization with the brutalities which modern tyrannical states
practice."
Reinhold Nieburhr, ca. 1940
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #2

P: n/a
By "quite a long time" I meant at least a few hours.
-David

ro***********@cox.net (Ron Johnson) wrote in message news:<1065896503.24193.53.camel@haggis>...
On Thu, 2003-10-09 at 11:05, David Shadovitz wrote:
I need to add a column to a table. This table holds several thousand
records, has several indexes, and serves as the parent table to a few
child tables.

When I've done this in the past, it has taken quite a long time for
the ALTER TABLE command to complete.

So, what is the correct procedure for adding a column? Drop the
indexes, add the column, and recreate the indexes?


Can you be more explicit about "quite a long time".

-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.