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