Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: There's one problem...
Michael G. wrote:
>
> When you drop your table you also drop all constraints created on this
> table, so you'd to recreate them.
Its easier to use a view minus the column and rename the table.
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Tue Apr 25 2000 - 00:00:00 CDT