Use this form to assign filegroups for tables, text and image fields, and to specify index parameters. Scriptoria includes this information when generating SQL Server data definitions.
Access Name: Shows the name of the current Access table. Use the navigation bar at the bottom of the form to traverse that tables collection.
Table Filegroup: This combo box lists all filegroups defined for the current SQL Server database. Select the filegroup you wish to assign to the table.
Text/Image Filegroup: Use this combo box to assign a filegroup for any text and/or image fields in the current table.
Index Name: Shows the names of the indexes for the current Access table.
Index Filegroup: Select the filegroup you wish to assign to the associated index.
Clustered: Optionally specify CLUSTERED or NONCLUSTERED for the associated index. Only one index per table may be clustered.
Notice in the above example that the Primary Key is specified as NONCLUSTERED. Since the Primary Key field is of type Auto Number and will not likely be used in query search criteria, it is not a good CLUSTERED candidate. A better choice is the LastName index.
PAD_INDEX: You can optionally specify a PAD_INDEX value. See the Transact-SQL manual for information on PAD_INDEX and Fill Factors.
Fill Factor: You can optionally specify a Fill Factor value.
IGNORE_DUP_KEY : You can optionally specify Yes/No for the IGNORE_DUP_KEY parameter - unique clustered indexes only.
Note that PAD_INDEX and IGNORE_DUP_KEY are ignored for Primary and Unique indexes.