Re: Simple Table Question

"Mike Cameron" <mikec_at_csckingston.com> a écrit dans le message news: G7zF4E.AMx_at_alfalfa.utcs.utoronto.ca...
> I know you can add a column to a table with the Alter command, is there
> anyway to delete a column?
>
>

In Oracle8i, you have

alter table <table> set unused column...
alter table <table> drop column...
alter table <table> drop unused columns...

In Oracle7, this is not available.
I don't remember for Oracle8 (8.0.x).

--
Have a nice day
Michel