Answer / karunakar reddy

No,In the entire table,there will be only one primary key.
A primary key is nothing but a collection of one or more
coloumns used to identify a row in a table.

Answer / dev lamani

no a table can have only one primary key.
u can make one or column to have primary key
that is called a composite primary key


Dev
ddlamani@yahoo.com

Answer / suresh somayajula

A table can have Only One Primary key. But a table can have
composite Primary key. that means we can create composite
primary key
upto 16 columns only.

suresh.
suresh_somayajula@hotmail.com

Answer / sankar

yes any table has only one primary key.but the basic idea
of pk is ....primary key=NOTNULL+UNIQUE KEY.which we can
give any column to a table and act as primary key

Answer / vaibhavi_dixit

A table can have only one primary key constraint but it can
consist one or multiple columns.If a primary key is made up
of more than one columns then it is know as composite
primary key.

VD

Answer / sowmya

Hi
A table can have only one primary key.but a primary key can
have two column fields
Ex i have a employee table.and i have fields eno,ename,esal
i can declare primarykey(esal,ename)

let me know if i am wrong

Answer / satish reddy

Each table can have only one primary key; however, that key may consist of more than one column.

SQL> create table EMP(EMPNO Number(5),EMPNAME Varchar2(10),ADDRESS Varchar2(10),Constraint Multi_Constr
aint Primary Key(EMPNO,EMPNAME));

After creating table try to insert null value into EMPNAME Column, it will throw an error "cannot insert NULL into ("SCOTT"."EMP"."EMPNAME")"

Answer / rahul khanke

primary key is only and only one in a table.
it may be in more column in table means
In one table --one primary key and more than one column on
the same table

Answer / murugavel. u

ya..it's possible when, a table contains more than one
fields. we can able to set the primary for two or more..

thanks.,

Answer / anish kumar anand

create table emp
(empno varchar2(10) constraint empnopk primary key,
e_id varchar2(10) constraint eiduk unique not null);

what is a foreign key ? : Sql dba

0 Answers  

what does the t-sql command ident_incr does? : Transact sql

0 Answers  

tell me about various levels of constraint. : Sql dba

0 Answers  

Why is partition used in sql?

0 Answers  

What is a cursor for loop ?

4 Answers  

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

What is the difference between unique and primary key constraints?

0 Answers  

Does sql*plus also have a pl/sql engine?

0 Answers  

What is RAC in oracle?

7 Answers   MCN Solutions,

What is write ahead logging in sql server?

0 Answers  

Why is sql important?

0 Answers  

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,