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.
Previous Topic: Mutating Error & constraining Error
Next Topic: why a parameter type number can get default 0?
Goto Forum:
  


Current Time: Sun Sep 19 12:15:46 CDT 2021