Trace the links to a column in SQL (primary key)
Posted on 2011-09-21
I wish to trace a link for a column (primary key) to see what other tables will be referencing it.
The reason for this is:
I have a problem with the way I entered the data into my sql DB.
I simply copy and pasted the data, which works fine until I insert a new data row through the software front end (Access Dimension) which crashes with a primary key dublication issue.
The old PK where pasted in and now when I get to an insert PK of 2 (the 2nd) it fails.
Alternatively a way to reset the PK value would suffice but the most common ways do not work as the field is a float.
any advise is very appriciated