Primary Key Name
Posted by:
yuyu san
Date: October 15, 2008 07:13PM
Hi ,
I would like to know primary key can explicitely be named in mysql ?
The following is how primary key can explicitely be named in oracle.
create table myTable (
a number,
b number,
c number,
constraint pk_name primary key (a, b))
In mySQL, I define primary key name as 'pkey_name'
ALTER TABLE myTable ADD CONSTRAINT `PKEY_NAME` PRIMARY KEY (A,B);
But primary key name is still 'PRIMARY' , not 'PKEY_NAME';
Any help?
Subject
Written By
Posted
Primary Key Name
October 15, 2008 07:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.