Configuration options for individual database tables

You can configure DDL options for individual tables and indexes in the database configuration file, database-config.xml. It is not possible to specify the DDL attributes of the primary key backing index (on column named with suffix ID) in the configuration file. These attributes use the DBMS default values.

This topic shows valid syntax in database-config.xml for configuring DDL options for each database type. All options are shown for reference.

Oracle

<database>
  ...
  <upgrade>
    <ora-db-ddl>
      <tablespaces admin="admin tablespace" index="index tablespace" op="op tablespace"
       staging="staging tablespace" typelist="typelist tablespace" lob="lob tablespace" />
      <ora-compression table-compression="ADVANCED|BASIC|NONE" index-compression="true|false">
      <ora-lobs type="BASIC|SECURE|SECURE_COMPRESSED" caching="true|false" /> 
      <ora-table-ddl table-name="pc_tableName">
        <ora-index-ddl key-columns="column1,column2" index-compression="true|false"
         index-tablespace="index tablespace">
          <ora-index-hash-partitioning locality="GLOBAL|LOCAL" num-partitions="number"/>
        </ora-index-ddl>
        <ora-lobs type="BASIC|SECURE|SECURE_COMPRESSED" caching="true|false" /> 
        <ora-table-compression table-compression="NONE|OLTP" />
        <ora-table-hash-partitioning hash-column="column name" num-partitions="number"/>
        <ora-table-tablespaces table-tablespace="table tablespace" lob-tablespace="LOB tablespace"
         index-tablespace="index tablespace"/>
      </ora-table-ddl>
    </ora-db-ddl>
  </upgrade>
</database>

SQL Server

<database>
...
  <upgrade>
    <mssql-db-ddl> 
      <mssql-filegroups admin="admin filegroup" index="index filegroup" op="op filegroup"
       staging="staging filegroup" typelist="typelist filegroup" lob="lob filegroup" />
      <mssql-table-ddl table-name="table name">
        <mssql-index-ddl key-columns="column1,column2" index-compression="true|false" 
         index-filegroup="index filegroup"/>
        <mssql-table-compression table-compression="NONE|PAGE|ROW"
         index-compression="NONE|PAGE|ROW" />
        <mssql-table-filegroups table-filegroup="table filegroup" lob-filegroup="LOB filegroup"
         index-filegroup="index filegroup"/>
      </mssql-table-ddl>
    </mssql-db-ddl>
  </upgrade>
</database>