IncludeRelatedTables

IncludeRelatedTables

is an option for RelationalDatabase that specifies whether to include tables specified in foreign keys.

Details

  • In the form RelationalDatabase[DatabaseReference[]], this option has no effect. However, in the form RelationalDatabase[{"table1","table2",},], the value of this option will determine whether only the tables tablei will be included or not.
  • With the default setting IncludeRelatedTablesFalse, only the specified tables will be inspected and included in the RelationalDatabase object.
  • With the setting IncludeRelatedTablesTrue, all tables that are referenced in the foreign key constraints are included recursively, even if they were not present in the first argument of RelationalDatabase.

Examples

Basic Examples  (1)

With the default setting, only the selected table is included:

Set IncludeRelatedTables to True to follow foreign key constraints:

Wolfram Research (2019), IncludeRelatedTables, Wolfram Language function, https://reference.wolfram.com/language/ref/IncludeRelatedTables.html.

Text

Wolfram Research (2019), IncludeRelatedTables, Wolfram Language function, https://reference.wolfram.com/language/ref/IncludeRelatedTables.html.

CMS

Wolfram Language. 2019. "IncludeRelatedTables." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/ref/IncludeRelatedTables.html.

APA

Wolfram Language. (2019). IncludeRelatedTables. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/IncludeRelatedTables.html

BibTeX

@misc{reference.wolfram_2022_includerelatedtables, author="Wolfram Research", title="{IncludeRelatedTables}", year="2019", howpublished="\url{https://reference.wolfram.com/language/ref/IncludeRelatedTables.html}", note=[Accessed: 05-December-2022 ]}

BibLaTeX

@online{reference.wolfram_2022_includerelatedtables, organization={Wolfram Research}, title={IncludeRelatedTables}, year={2019}, url={https://reference.wolfram.com/language/ref/IncludeRelatedTables.html}, note=[Accessed: 05-December-2022 ]}