How do you create a primary key to existing table with duplicate records?

  • Interview Candidate
  • 1
  • 1733

Showing Answers 1 - 1 of 1 Answers

hemant.agarwal03

  • Mar 17th, 2008
 

alter table <table_name> add constraint <constraint_name> primary key (<col_name>)
DEFERRABLE initially immediate enable novalidate

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions