Database Table Info reports

The Server Tools > Info Pages > Database Table Info screen provides the following reports.

Report	Description
All Tables	Lists information about PolicyCenter tables.
Array Membership	Lists the different tables that own an array, if any.
Array Ownership	Lists the different arrays that a table owns, if any.
Change Data Capture Info	(SQL Server) Lists tables for which change data capture is enabled. You must enable the database for change data capture for this report to be available. Refer to the following Microsoft site for further information. https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-data-capture-sql-server?view=sql-server-2014
Event Paths from Tables to Listening Objects	Shows paths from event-generating entities to non-event-generating entities. Each row in the table contains a non-event-generating entity `E`, along with one of the paths from an event-generating entity to `E`. PolicyCenter uses each path to generate a query to find the event-generating entity instances that reference an instance of the non-event-generating entity.
Event Paths to Listening Tables	Shows the same paths as those in the Event Paths from Tables to Listening Objects report, but the entities in the second column are the event-generating entities. Each entry in the table contains an event-generating entity `E`, along with a path from `E` to a non-event-generating entity.
Foreign Key Constraints by Table	Lists the foreign key constraints on tables and provides information about the tables referenced by the keys.
Guidewire Version	Lists schema version and build information for PolicyCenter.
Implemented Interfaces	For each entity table, lists the interfaces that the entity implements.
Indexes by Table	Lists the indexes on a table and provides information about the associated key columns.
Indexes without a Description	Lists indexes that do not have a description.
Indexes with Shared Prefixes	Lists indexes that share multiple leading key columns. It is possible to use this information to find redundant indexes.
Indexes with the Same Key Columns	Lists indexes that have the same key columns.
Instrumentation Queries	Lists the queries that PolicyCenter executes against the database while building the data the comprises the download reports.
Number of columns	Displays the number of columns of various types in each table.
Possibly Redundant Backing FK Indexes	Lists foreign key indexes that may be redundant, including information about whether the index is unique and if it is an extension.
Primary Key Constraints by Table	Lists the primary key constraints on tables and provides information about the fields that reference the keys.
Referencing Eff dated foreign keys by Table
Replication Info	(SQL Server) Lists tables for which replication is enabled.
Schema Verification Errors	Lists database schema errors. The report is only present if there are errors.
Spatial Indexes	Provides information about spatial indexes.
Typekey Columns by Typelist	Lists the referencing typekey columns for each typelist.

PolicyCenter copies table-specific information from each report category to the individual report for the respective table, excepting the All Tables and Instrumentation Queries reports.