Re: dropping a column in a production database
Date: Wed, 02 Jul 2008 16:00:05 +0200
> 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.
What could be unexpected?
The fact that was part of a key, used for referential integrity of your system?
The fact that is was part of a highly selective index, the sped up the majority of your work by a factor 100?
Nah - can't be - just told you ;)
-- Regards, Frank van BortelReceived on Wed Jul 02 2008 - 09:00:05 CDT