Re: Drop coloum in Table

Not in Oracle versions prior to 8.1.5. If using 8.1.5 and above then you can use the
alter table drop column column_name cascade constraints; command

HTH NeilC

Garsen Subramoney wrote in message <7v168t$1t02$1_at_nnrp01.ops.uunet.co.za>...
>Hi
>
>Is there a quick and easy way of dropping a column in a Table that has
>constraints against it and which has data in it.
>
>
>
>
Received on Mon Oct 25 1999 - 04:17:54 CDT