0

Table Name => PropDocument
Column1 => propertyid ( foreign key from Property table )
Column2 => documentid ( foreign key from Document table )

The error ( in the attached image ) comes when
I try to delete the record.
This error comes often when there are 2 records with same values as you can see in the image.

By mistake I have added that records but
now how can I delete the records ?

Attachments ErrorWhileDeleting.jpg 91.92 KB
2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by Nitin Daphale
0
ALTER TABLE Table1

ADD TempID int IDENTITY(1, 1)

Run this in SQLBrowser

It will create another Column and make everything unique

Delete what you want and then delete the column

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.