Re: Drop a table with foreign key constraints
- From: Jared Still <jkstill@xxxxxxxxx>
- To: uwe@xxxxxxxxxxxx
- Date: Sun, 1 Aug 2010 11:10:44 -0700
2010/8/1 Uwe Küchler <uwe@xxxxxxxxxxxx>
> Octavian,
>
> have you considered using a view as an API to the table? This way, you
> could re-order, rename and even drop columns without caring about FK
> constraints.
>
>
A couple of thoughts on that spring to mind:
* any app that does 'select *' and expects columns in the current order will
break.
It does not matter that 'select *' is a bad idea, that never stopped anyone.
Dang, while typing the first one, I forgot the second one.
Oh well...
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
