Re: Drop a table with foreign key constraints
- From: "Octavian Rasnita" <orasnita@xxxxxxxxx>
- To: Uwe Küchler <uwe@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 1 Aug 2010 22:58:57 +0300
Hi Uwe,
Thanks for confirming me that this is a good choice.
Yes, I was thinking that this could be also a solution for what I want because
it is more simple to do.
Octavian
----- Original Message -----
From: "Uwe Küchler" <uwe@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>; <orasnita@xxxxxxxxx>
Sent: Sunday, August 01, 2010 8:27 PM
Subject: Re: Drop a table with foreign key constraints
> 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.
>
> Just trying to K.I.S...
>
> Regards,
> Uwe
>
>
>>
>> From: "Octavian Rasnita" <orasnita@xxxxxxxxx>
>> Subject: Re: Drop a table with foreign key constraints
>> Date: Fri, 30 Jul 2010 22:35:47 +0300
>>
>>> > The alternative solutionsfor the OP are:
>>> >
>>> > - as Dick says, don't bother reorganising columns
>>>
>> I am storing the balance sheet positions which are displayed in a certain
>> order, and it would be easier if the table would have them in that order.
>> And I might need to add some sub-positions in that balance sheet...
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
