Home » RDBMS Server » Server Administration » Constraint removal
Constraint removal [message #373090] Tue, 27 March 2001 04:58 Go to next message
Prabhash Kumar
Messages: 1
Registered: March 2001
Junior Member
create table emp_raise
(raise_date date,
emp_id varchar2(6),
primary key(raise_date,emp_id));

Now I have to remove the constraint that is associated with raise_date column.How will i do that?

Report message to a moderator

Re: Constraint removal [message #373091 is a reply to message #373090] Tue, 27 March 2001 05:12 Go to previous message
Thirumalai and Prakash
Messages: 23
Registered: March 2001
Junior Member
Hi Prabhash kumar,
Use this statement to drop primary key.

ALTER TABLE emp_raise DROP PRIMARY KEY;

Hope it helps !

Regards
S.Thirumalai

Report message to a moderator

Previous Topic: Re: Dropping all tables at once
Next Topic: Update script
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 06:15:52 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.