Its possible to add more than one primary key for the table

Answer Posted / mahesh katkam

NO its not possible to add more than one primary key in one table , but using trigger we can make another non_primary column acts as primary key column.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql in java?

755


what are sequences

1315


How can you fetch first 5 characters of the string?

707


What are few of the schema objects that are created using PL/SQL?

733


How do I make my sql query run faster?

662






How many types of tables are there?

692


Can we use pl sql in sql server?

739


What is view? Can we update view

1081


how to get a list of columns in an existing table? : Sql dba

709


How do we use distinct statement? What is its use?

750


What are the differences between in and exists clause?

784


What is difference between nchar and nvarchar?

694


Can we perform dml on view?

737


What is the difference between pl and sql?

734


What are the types of records?

741