alter ignore table <tablename> add unique key (field1,field2,....);

how to delete duplicate rows in sql server 2005?

Question Posted / balaji

Answer Posted / balaji

alter ignore table <tablename> add unique key
(field1,field2,....);

Is This Answer Correct ?

1 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Why mysql is open source?

483

What is the maximum number of columns per table?

485

How to show certain selected rows with the value "pcds".

506

How do I restore a mysql database?

538

Explain the difference between delete and truncate.

535

What is an example of a delimiter?

488

Explain the different types of constraints?

516

How do you rename a table?

514

How to create a table index in mysql?

524

What is mysql and why it is used?

556

What is mysqli procedural?

518

What is heap table in mysql?

496

What mysql -u john -p command does?

512

How do I use mysql?

485

Can we write procedure in mysql?

501