Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT!!! How can I drop a column???
Using SQLPlusPlus (freeware) you could generate a script to alter a
table to
your heart's content.
For example to alter DEPT table, we could generate the following script.
SQL> EXEC S2.BLDALT('DEPT','SCOTT')
| ----------------------------------------------------------------------
PL/SQL procedure successfully completed.
SQL> SPOOL OFF
regards,
M. Armaghan Saqib
+---------------------------------------------------------------| 2. SQL Link for XL => Integrate Oracle with XL
| 1. SQL PlusPlus => Add power to SQL Plus command line
+---------------------------------------------------------------
+---------------------------------------------------------------
Emilie Carton <emilie_carton_at_hotmail.com> wrote in message news:8aq654$2rm$1_at_fe1.cs.interbusiness.it... > how can I drop a single column from a table without losing the whole my
> dates? > I tried to do with using: > sql> alter table "table name " drop "column name"; > but it answers me back "missing keyword"... > How can I solve this problem? > > Thanks a lot > Emilie > > > >
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Mar 20 2000 - 00:00:00 CST
![]() |
![]() |