Home » RDBMS Server » Server Administration » Dropping column in 7.3.4
Dropping column in 7.3.4 [message #50228] Wed, 06 March 2002 10:50 Go to next message
srs
Messages: 5
Registered: March 2002
Junior Member
Hey slum do you know the procedure for dropping a column in a table which has references to other table.

Report message to a moderator

Re: Dropping column in 7.3.4 [message #50229 is a reply to message #50228] Wed, 06 March 2002 10:56 Go to previous messageGo to next message
saleem
Messages: 65
Registered: January 2002
Member
first drop the constraint that references that table. next alter table blah_blah drop (column_name, columN_name);

you'll have to double check the syntax.

Report message to a moderator

Re: Dropping column in 7.3.4 [message #50231 is a reply to message #50228] Wed, 06 March 2002 11:03 Go to previous message
shafik
Messages: 13
Registered: March 2002
Junior Member
SQL> alter table vot1 drop (LAST_UPDATED_BY , VARCHAR2(10));
alter table vot1 drop (LAST_UPDATED_BY , VARCHAR2(10))
*
ERROR at line 1:
ORA-00905: missing keyword

Dosent work.

Report message to a moderator

Previous Topic: DBA password
Next Topic: Migrating from Sybase Database to Oracle 8x
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 12:08:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.