I have to do this all the time as our database schema is always
changing. As long as you are careful not to drop anything that is
used in a stored procedure or trigger you shouldn't have any problems.
I never have.

Having said that, I always make sure that I have a good backup before
I start messing about. It also helps the make sure that no one is
attached to the database in question. That avoids a lot of annoying
"object is in use" errors.

Steve Boyd

On Thu, 13 Feb 2003 12:18:17 +0000 (UTC), tiago@... (Tiago
Costa) wrote:

>Hello,
>
> I wonder if it is safe to do several "ALTER TABLE xxx ADD fname type",
>"DROP INDEX", "CREATE INDEX" in a live database or it can cause corruption?
>
>TIA,
>Tiago
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>