Hello Yu, Sorry for the delay in answering your question. The table relationships for Genome Browser databases are captured in this file in our source tree:
src/hg/makeDb/schema/all.joiner See this link for downloading the source: http://hgdownload.cse.ucsc.edu/downloads.html#source_downloads It is free for academic, nonprofit and personal use. Commercial use requires a license. The file joiner.doc in the same directory as above describes all.joiner and how to use it. The tool "joinerCheck" can be used to parse the all.joiner file. Run it without arguments for a usage statement: $ joinerCheck joinerCheck - Parse and check joiner file usage: joinerCheck file.joiner options: -fields - Check fields in joiner file exist, faster with -fieldListIn -fieldListOut=file - List all fields in all databases to file. -fieldListIn=file - Get list of fields from file rather than mysql. -keys - Validate (foreign) keys. Takes about an hour. -tableCoverage - Check that all tables are mentioned in joiner file -dbCoverage - Check that all databases are mentioned in joiner file -times - Check update times of tables are after tables they depend on -all - Do all tests: -fields -keys -tableCoverage -dbCoverage -times -identifier=name - Just validate given identifier. Note only applies to keys and fields checks. -database=name - Just validate given database. Note only applies to keys and times checks. I hope this is helpful. If you have further questions, please write back to [email protected]. -- Brooke Rhead UCSC Genome Bioinformatics Group On 11/27/08 23:44, Yu Zhou wrote: > Hello, > > Is there a script equivalent to function of the button 'describe table > schema' in Table browser? I need to view connected tables for any > given table dynamically. Thanks a lot in advance! > > > Best regards, > > Yu > _______________________________________________ > Genome maillist - [email protected] > http://www.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] http://www.soe.ucsc.edu/mailman/listinfo/genome
