The <mssql-table-ddl> database configuration element

The <mssql-db-ddl> element in file database-config.xml can contain any number of occurrences of subelement <mssql-table-ddl>. The use of the <mssql-table-ddl> element is optional. Use this element to specify DDL (Data Definition Language) options for a specific, named SQL Server database table.

The <mssql-table-ddl> element has the following syntax. The following code sample shows required attributes in bold font. 

<database>
  <upgrade>
    <mssql-db-ddl>
    <mssql-table-ddl table-name="string">
      <mssql-index-ddl filter-where="string"index-compression="NONE|PAGE|ROW"
            index-filegroup="string" key-columns="string" partition-scheme="string"/>
      <mssql-table-compression index-compression="NONE|PAGE|ROW" 
            table-compression="NONE|PAGE|ROW"/>
      <mssql-table-filegroups lob-filegroups="string" index-filegroup="string" 
            table-filegroup="string"/>
      </mssql-table-ddl>
    </mssql-db-ddl>
  </upgrade>
</database>

The <mssql-table-ddl> element has the following attribute.

table-name

Required. Name of the table to which these overrides apply.

The <mssql-table-ddl> element has the following subelements. Each of these elements is optional. There is, at most, a single occurrence of the <mssql-table-compression> and <mssql-table-filegroups> elements on the <mssql-table-ddl> element. There can be, however, multiple occurrences of the <mssql-index-ddl> element.

mssql-index-ddl

Specifies DDL options for a specific index. See The <mssql-index-ddl> database configuration element for more information.

mssql-table-compression

Specifies compression for the named table. See The <mssql-table-compression> database configuration element for more information.

mssql-table-filegroups

Specifies a filegroup to associate with a table, index, or LOB. See The <mssql-table-filegroups> database configuration element for more information.

See also