Re: How can I drop a column from a table?

M Rajeshwar wrote:
> Jarmo Tuominen wrote:
> > What is the best way to drop a column from the table? Is there any command for this?
> But this can be achieved in the followin way.
> Assume you have a table TABLE with columns c1,c2 and c3, and that you
> want to delete column c2.
> Create a temporary table temptab as
> CREATE TABLE TEMPTAB AS SELECT C1,C3 FROM TAB;
> Drop the original table TABLE as, DROP TABLE TABLE;
> Rename this temporary table back to its original as,
> RENAME TEMPTAB TO TABLE;
> So, that will leave the table TABLE with one column deleted !!!

How do we manage the following problems:

• Grants
• indexes
• packages
• snapshots
• aso.

Wouldn't they (at least some of them) go invalid?

Mitro Received on Tue Jul 30 1996 - 00:00:00 CEST