SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Finding Table Relation Columns		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

CP
Starting Member

9 Posts
Posted - 04/26/2012 :  12:01:32  Show Profile  Reply with Quote
I am using Microsoft SQL Server Management Studio 2008 to retrieve information from AX 2012. The table relations in the AX AOT is just what I'm looking for, however I will not have access to them. Is there a way that I can get the table relations by using a query?

Here's an example of what I am looking for:

TableName    ColumnNameofTable          RelatedTableName        ColumnRelatedto
Custtable    ContactPersonID            ContactPerson           RecID

OR

Something that would give me this:
Custtable.contactpersonId == ContactPerson.RecId


Let me know if I need to give more information.

visakh16
Very Important crosS Applying yaK Herder

India
47023 Posts
Posted - 04/26/2012 :  12:18:26  Show Profile  Reply with Quote
so is it through linked server setup you access those tables?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

CP
Starting Member

9 Posts
Posted - 04/26/2012 :  12:38:10  Show Profile  Reply with Quote
Yes I believe so.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47023 Posts
Posted - 04/26/2012 :  12:42:04  Show Profile  Reply with Quote
I dont think so you'll be able to extract out table relationship detail from AX using linked server.
you can get metadata information about AX tables though in sql server by dumping it into temporary table and querying against catalog views for it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000