The <mssql-table-filegroups> database configuration element

The <mssql-table-ddl> element in file database-config.xml contains, at most, a single occurrence of subelement <mssql-table-filegroups>. The use of the <mssql-table-groups> element is optional. Use this element to associate a filegroup with a table, index, or LOB. Any value that you set at this level overrides that same value set at the global, database level.

The <mssql-table-filegroups> 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-table-filegroups table-filegroup="string" index-filegroup="string" 
              lob-filegroups="string"/>
      </mssql-table-ddl>
    </mssql-db-ddl>
  </upgrade>
</database>

The following list describes the attributes that you can configure on the <mssql-table-filegroups> element. All of these attributes are optional. However, if you do not specify at least one of these attributes, there is no need for this element to be present in database-config.xml.

table-filegroup

Name of the filegroup to associate with this table.

index-filegroup

Name of the filegroup to associate with any indexes on this table.

lob-filegroup

Name of the filegroup to associate with any large object (LOB, CLOB, or spatial column).

The <mssql-table-filegroups> element does not contain additional subelements.