Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to locate a column

Author  Topic 

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2014-08-21 : 11:08:55
I have just loaded some tables to our main db.
there is a col in one table called
MAPCONCEPTID.
I want to know how to find where MAPCONCEPTID field in one of the table is mapped to.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-08-21 : 12:30:10
What do you mean by "mapped to"? Are you referring to a referential integrity/foreign keys? If a foreign key doesn't exist, then there isn't a way to find the relationship unless the column is named the same in other tables or by running a trace.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

bitsmed
Aged Yak Warrior

545 Posts

Posted - 2014-08-21 : 18:17:32
Maybe the following link can help (it's certainly interesting reading). Please post your solution if you find one, so we all can learn how it's done.
[url]http://msdn.microsoft.com/en-us/library/aa175805(SQL.80).aspx[/url]
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-23 : 02:14:04
Do you mean some sort of object mapping , where a database schema is extracted and mapped from the application side?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -