Search SSWUG.ORG:



DATABASES

Capture MySQL Foreign Keys This is an off-site link.  Please review our Terms of Service for additional information.


(Michael McLaughlin) Shantanu asked a follow-up question on my Cleanup a MySQL Schema post from last month. He wanted to know if there was a way to capture foreign keys before removing them. The answer is yes, but how you do it depends on whether the primary key is based on a surrogate key using an auto incrementing sequence of a natural key using descriptive columns.

Read this article..







comments powered by Disqus