Primary Key ....

From: Ariji Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 11 Mar 2005 20:40:15 -0800
Message-ID: <1110602415.016321.80670@o13g2000cwo.googlegroups.com>

Dear Faculties,
Here I have created a table in two manner ..

---

SQL> create table Test
  2 (
  3 PK number(10,0) not null,
  4 Name varchar(10)
  5 );

Table created.

SQL> Alter table Test add constraint UK_Con Unique(PK);

Table altered.

Here Number of contraints is TWO.

---

SQL> drop table test
  2 /
Table dropped.

SQL> create table Test
  2 (
  3 PK number(10,0) primary key,
  4 Name varchar(10)
  5 );

Table created.

Here Number of contraints is ONE.

---

Both the case "PK" column is exist.
In the first scenario "PK" column can called as primary key ? Even if it is not declared as "primary key"? Thanks in advance.
Regards
Arijit Chatterjee Received on Fri Mar 11 2005 - 22:40:15 CST