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.
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
yes, a table may have more than 1 primary keys but, of them
we only choose 1 column as identifiable column called
primary key. The other columns are called surrogate keys or
candidate key.
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
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
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
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
Yes table can have two or more primary key,when we want to
create more then one primary we use unique constranit with
not null or we can create with triggre.
No, a table should allows only one primary key with the
properties of NOT NULL + UNIQUE . But user can be able to
give more than one primary keys in a table with the help of
NOT NULL and UNIQUE KEYs but not directly using PRIMARY KEY
constraint.
Which one of the following join types will always create a
Cartesian Product?
1. CROSS JOIN
2. LEFT OUTER JOIN
3. RIGHT OUTER JOIN
4. FULL OUTER JOIN
5. INNER JOIN