Toad World® Forums

Reversing sp_primarykey and sp_foreignkey


#1

Any chance of reversing sp_primarykey and sp_foreignkey and using it to generate link in Database Diagram?

We don’t use declarative referential integrity. Everything is done using triggers. We also have some programs using the info from sp_primarykey and sp_foreignkey.

create.zip (446 Bytes)


#2

I created CR 81,162 to track this request.

Thanks.


#3

While we are working on this, I would like to mention that you can manually create the relationships in the database diagram and they will automatically be saved to the object annotation cache. The next time you reference the object in a diagram the manual link will be pulled from the cache and shown in the diagram.

Thanks.