Home » SQL & PL/SQL » SQL & PL/SQL » Re: Linking table fields in oracle
Re: Linking table fields in oracle [message #18547] Tue, 05 February 2002 03:13
Mike
Messages: 417
Registered: September 1998
Senior Member
ALTER TABLE skills ADD PRIMARY KEY (name_id)
or
ALTER TABLE skills ADD CONSTRAINT u_name_id UNIQUE (name_id)

You can only do both of them if name_id is unique.

Report message to a moderator

Previous Topic: Mutating Error & constraining Error
Next Topic: why a parameter type number can get default 0?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 15:54:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.