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

Follow-Ups:

Re: Drop a table with foreign key constraints
From: Uwe Küchler

References:
- Re: Drop a table with foreign key constraints
  - From: Uwe Küchler

Re: Drop a table with foreign key constraints

Other related posts: