5
Reply

Can a table have more than one Primary Key ?

Pavan Ramamurthy

Pavan Ramamurthy
2y
2.2k
2
Reply

Commonly asked question in an interview ?

    Tanima K
    No, but can have more than one unique keys constraints.
    Tanima K
    2y
    1
    Kousalya Palani
    No. But you can do it by using composite primary key, which consists of multiple columns, to uniquely identify each row in a table
    Kousalya Palani
    2y
    0
    Abhijit Das
    no
    Abhijit Das
    2y
    0
    Vijay K

    No,You cannot have two primary keys in one table.But primary can contain multiple fields.When you create table,when you mention primary key you can more then one column which you want.
    like,
    CREATE TABLE table_name ( col1 Datatype , col2 Datatype,col3 Datatype, col4 Datatype, PRIMARY KEY (col1,col2,col3) )

    Vijay K
    2y
    0
    Kavya Chowdary

    No. Because Primary key is an identity to the row. There cannot be two identities against a row.

    Kavya Chowdary
    2y
    0
Message