Re: dropping a column in a production database

From: yossarian <yossarian99_at_operamail.com>
Date: Wed, 02 Jul 2008 14:38:38 +0200
Message-ID: <486b76ce$0$17931$5fc30a8@news.tiscali.it>


Ed Prochak wrote:

> It is safe in the sense that it will do exactly what you ask. Any data
> in that dropped column will be gone (forever if you do not have it in
> a backup). Note that any applications that used that column will need
> to be rewritten. Packages, functions and procedures dependent on that
> column will become invalid and need to be rewritten. It's all standard
> stuff.

OK, thank you. I was just wondering about unexpected side effects.

Kind regards, Y. Received on Wed Jul 02 2008 - 07:38:38 CDT

Original text of this message