-
Junior Member
plz give me a solution to my doubts..
Dear Friends,
Can any one give me a solution to my doubts?
My doubts are 1. can we add unique constraint to a table which already have duplicate rows. Is it any way that we can add unique constraint to a table which has duplicate rows? ( I don't want to delete duplicate rows from table).
2. I have a table which consist of 20 records.I want to delete 19 records out of 20. Can any one tell how to delete 19 rows from table without using where condition?
Regards
Rajesh
-
Junior Member
Re: plz give me a solution to my doubts..
Hi Rajesh,
u cant not add a unique contraint to a column of a table containing duplicate rows as Existing data is checked against the new condition before the statement succeeds.
Regards
Risham
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules