On Wed, Apr 22, 2015 at 1:55 PM, Kurt Wendt <[email protected]> wrote:

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


Just a start on this wide topic of Constraints:
https://technet.microsoft.com/en-us/library/ms189862%28v=sql.105%29.aspx

There are sprocs to help out as well:

sp_helpconstraint N’tableName’

Thsi will get you the indexes as well as the table references.




-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- 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/cajidmy+o23qriarxzpzb6+xwmtiajfss4bc_8ok77twv974...@mail.gmail.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.

Reply via email to