|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#2
October 5th, 2004, 09:39 AM
|
||||
|
||||
|
Something like:
Code:
ALTER TABLE SCOTT.BONUS DROP (ENAME)
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#4
October 9th, 2004, 05:13 AM
|
|||
|
|||
|
Quote:
According to the Oracle manual (http://download-uk.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/statem2a.htm#2054899) you need to include the COLUMN keyword and remove the brackets if you only want to drop a single column ALTER TABLE xxx DROP COLUMN col_name; You should really start reading manuals, they do have answers for exactly these kind of questions 
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > delete column please |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
delete column please
But .... !
Linear Mode
