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/1429718906.3621321.257201433.27295...@webmail.messagingengine.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.
