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
---
_______________________________________________
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.
