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 ?

Recommended Answers

All 2 Replies

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

Thanks finito
It worked .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.