HughbertD Posted January 5, 2008 Share Posted January 5, 2008 Hi I was wondering if anyone knew how you can query a primary key to see if it is referenced as a foreign key in other tables. basically I want to do a delete cascade, but I want to give the user a chance to change the rows of data that reference the primary key first. Thanks to anyone that can help Quote Link to comment Share on other sites More sharing options...
fenway Posted January 5, 2008 Share Posted January 5, 2008 Maybe there's a way in v5 with information_schema tables, but I don't know for sure. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.