Thanks Alan! I followed the link - and, yes - people on there mentioned a bunch of options. The initial reply though, it was the one using MS SQL Mgmt Studio - and I basically followed what it suggested - and my manager here made the same suggestion. As she pointed me in the same direction. Although, strangely - it made the "Diagram" based upon the Tables I selected - but, showed NO Linkages between ANY Tables - which of course is really what I am after. I will have to ask here what the deal is. I know there are 2 types of linkages I believe - according to my recent reading - and I think they only deal with the one kind of linkage here. But, about that I could be completely wrong.
Anyway - thanks for pointing me in the right direction. I may soon even have to show you guys a prototype I did (U know - my 3D Printing stuff) - which I am now using here at work. Some folks have seen it and think its pretty wild! I made it to solve a problem here at work - re:desk space. L8r, -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Alan Bourke Sent: Wednesday, April 22, 2015 12:08 PM To: [email protected] Subject: Re: A Proj, Linked Tables & MS SQL - Oh My... Well, there's probably any number of ways. http://stackoverflow.com/questions/168724/generate-table-relationship-diagram-from-existing-schema-sql-server -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Wed, 22 Apr 2015, at 05:02 PM, Kurt Wendt wrote: > So - I have this project here at work. A request was made to delete a > couple records in a Table. And, the user also mentioned that there are > a couple of related records in another Table - which also must be Deleted. > > Of course, considering its MS SQL we are talking about - similar to > the DBC in VFP - I must make sure I delete the proper records - and > those records that are also related. At best, as a starting point - I > must find out all the records related to the main ones that they are > asking to get Deleted. > > My plans are to probably do this via VFP Code to delete the proper > records. Since we are still largely using VFP as the Front End - while > the main Tables are all in MS SQL. > > One of my co-workers here pointed me to this SQL Server Central > website - to learn more about MS SQL. So - in one of the webpages in > this Stairway series - there is pic showing related tables in their example > project. > > My question - is there a way in, say - MS SQL Server Mgmt Studio - to > generate a graphical display of the linked Tables - similar to this > pic from the Stairway series(?): > http://www.sqlservercentral.com/images/11014.png > > TIA, > -K- > > GLOBETAX > 90 Broad Street > New York, NY 10004-2205, U.S.A. > Tel. +1-212-747-9100 > Fax. +1-212-747-0029 > Email: [email protected]<mailto:%[email protected]> > Web: www.GlobeTax.com<http://www.globetax.com/> > > GlobeTax does not provide or offer, and this is not, tax, investment > or legal advice. This email and any attachments hereto is intended > only for use by the addressee(s) and may contain confidential > information. If you are not the intended recipient of this e-mail, > please immediately notify the sender at +1-212-747-9100 and > permanently delete the original and any copies of this e-mail. > > > > > --- StripMime Report -- processed MIME parts --- multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b1...@drexch02.corp.globetax.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
