Subject | Primary Key vs Constraint Primary Key |
---|---|
Author | chee hee |
Post date | 2006-05-30T05:21:34Z |
Hi All,
What is the different between these two statements and which one is preferred:
ALTER TABLE CUSTOMER ADD PRIMARY KEY (CUST_NO);
ALTER TABLE CUSTOMER ADD CONSTRAINT PK_CUST PRIMARY KEY (CUST_NO);
Thanks.
CM
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
What is the different between these two statements and which one is preferred:
ALTER TABLE CUSTOMER ADD PRIMARY KEY (CUST_NO);
ALTER TABLE CUSTOMER ADD CONSTRAINT PK_CUST PRIMARY KEY (CUST_NO);
Thanks.
CM
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]