Printable View
This is an Oracle dababase 10.2.0.4 on solaris 10.
I want to remove the primary keys from specific tables on certain named columns. Also I want to drop the specific named columns from the table.
I will appreciate suggestions as to the best possible approach.
Thanks,
Lucky
Check business requirement one more time...
If sure... go and ask again...
Test it... Test it... Test it...
Drop PKs
- Research alter table drop constraint to get rid of PK
Drop columns
- You should also get rid of all indexes referencing columns you want to drop
- I would create new tables, like CTAS