Re: How does one find all tables related to a given table?
I'm sure no-one other than John Van Breda can answer this, but I'm posting this question here in the hope he has time to answer and so that all may benefit from the answer.
When an export is performed on, say, a Survey, Recorder is able to detect all of the data related to that survey and thus export it. My question is: how does Recorder perform this 'spidering' of the database in order to know what to export? Is it something that can be done in Transact-SQL? If so, how (if it's not too complex to explain)? If it isn't done purely in T-SQL, what is (roughly) going on?
Cheers,
Charles
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital