Is there a way to reverse engineering a relational database from a stored procedure?
I can map out the database manually but it would be nice to know if there's any tool (visio?) to do the job and save time.
Thank you
Hi Don,
Of course you can ALTER the database design through many conventions including stored procedures, but it sounds like you're looking for relationship diagrams and such strictly for documentation purposes?
Visio should work fine for you.
Adamus
I hope these links help you.
http://msdn2.microsoft.com/en-us/library/aa140264(office.10).aspx
http://msdn2.microsoft.com/en-us/library/aa662937(office.11).aspx
If you find them useful, please mark this post as useful.