Table Sets

Table Sets are sets of tables that come from 1 datbase. If you have a very large database with hundreds of tables it is likely that not all tables are connected to each other. For reporting purposes it would not be benificial to have the configuration for all tables in one extremely large file.

Create for every group of tables a separate Table Set. This way you can build reports on tables that actually have a relation to each other.

  • TableSet Name: The name of the TableSet must be unique per connection. This is a required field. Use the default button to enter the default TableSets name.
  • Default Path: This is the path that will be used for all files used by a TablesSet. Use the button to enter the Default Configuration Files path.
  • Autofill Default Values: if this checkbox is checked all other values will automatically be entered.
  • Tables File: The name and path of the file that will hold your table definitions. For information about table definitions see the manual chapter “Tables”. 
  • Output Path: The default location where export files will be saved to. A dot: “.” represents the Sequenchel startup folder.
  • Report Set Name: The name of your report set. At this time only one report set per table set is possible.
  • Reports File: The path and name of your report definition file. This is the file that will hold your report definitions. For more information see the chapter “Reports” in the manual.
  • Search File: The path and filename for the configuration file where your custom searches are saved to.

Choose 1 table set to be the default table set. This set will be loaded automatically when the parent connection is selected.

If you have multiple identical databases, for instance a Sequenchel database in Test, Acceptance and Production environment, you could declare the same TableSets file or Tables file for all 3 connections. This way you only have to configure 1 environment and the others are updated automatically.