Alter table

[Guest_imported]

How do I delete a single column from an Oracle 8i table? I've tried using alter table tablename drop column columname in SQL WorkSheet but it generates a missing keyword error. Please help.

 

[rcurva]

You can try this,
ALTER TABLE tablename DROP (column1);

You can also set the columns unused before dropping:

1. Will mark a column unused.

alter table <table_name> set unused (col1,col2,col3,...);

2. This will drop the column from table.
alter table <table_name> drop column (col1,col2,col3,...);
or
alter table <table_name> drop unused columns;

Hope this helps.

 

[raj28]

Hi scallums,
Just go this site

http://www.jlcomp.demon.co.uk/faq/debugplsql.html

Hope this helps u

Raj28.....

 

[raj28]

Sorry friends,
I want to reply for other question but i replied here by mistake.

Raj28.....