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.
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 calledMAPCONCEPTID.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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
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] |
|
|
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 |
|
|
|
|
|