Re: drop column ?

> I'm new in Oracle 8i,
> can we drop a column from a table in oracle 8i ?
> does someone know how to do that ?

ALTER TABLE tab_name DROP (col_name) CASCADE CONSTRAINTS;

hope this helps,

    Marin

"The important thing for all of us is never look *at* the bars, look *through* them. Because if you keep looking *at* bars, you'll never get anything done, and you'll never have fun in life, any joy."

                                                  William Wharton, "Pride"