Hi All,

How to find total number of “Foreign key” references for a “Primary Key” value. Is there any system stored procedure.

For example “UserId“ is my primary key field. “User102” is the value, suppose If I am using this value in other tables, how to find number of references.

Plz help me on this.

Regards,
SSV.

If you have defined the foreign keys, you can make a new diagram, select the table with the primary key, click the Add button and check the 'Add related tables automatically' checkbox. It will build a diagram showing you all of the related tables.

Thanks for your reply. Actually I am displaying all the (primary key) records in the data grid, if particular value referenced in another table than I want to make that one read-only. So I want to know total number of references, if it is more than zero I can make it read-only . Otherwise I have to maintain”UsedCount” column in each table which I have to update each time.

Is there any procedure/trick that returns NUMBER primary key value references?

SSV

Sysobject Table in database. There are all objects of databases.

Peko