The Database Properties window displays the schema definitions that define the database, such as the database name and the database type of the working database. To access this window, click the Database Properties button on the main window.

The Database Properties window contains the following fields:
  • Logical Name—Displays the logical name for the working database.
  • Physical Name—Displays the physical name for the working database, as specified at connect time.
  • Schema Holder—Displays the schema of the working database.
  • Type—Displays the database type for the working database.
  • Code Page—Displays the code page for the working database.
  • Table partitioning—Indicates if table partitioning is enabled or disabled.
  • Multi-tenancy—Indicates if multi-tenancy is enabled or disabled.
  • Change Data Capture—Indicates if Change Data Capture is enabled or disabled.
  • 64-bit Sequences—Indicates if 64-bit sequences are enabled or disabled.
  • Large Key Entries—Indicates if large key entries are enabled or disabled.
  • Table Default Area—Displays the name of the default area for creating tables if set, or displays the string n/a if not set. A new default area can be set from the options in the drop-down list. If the default area is set to blank, then the default area uses a null value.
  • Index Default Area—Displays the name of the default area for creating indexes if set, or displays the string n/a if not set. A new default area can be set from the options in the drop-down list. If the default area is set to blank, then the default area uses a null value.
  • LOB Default Area—Displays the name of the default area for creating large objects (LOBs) if set, or displays the string n/a if not set. A new default area can be set from the options in the drop-down list. If the default area is set to blank, then the default area uses a null value.
  • Description—Allows you to enter a description of the database. Use this field to differentiate between databases that share the same name but have unique database identifiers.
  • Additional Details—Allows you to enter additional information about the database. Use this field to differentiate between databases that share the same name but have unique database identifiers.