Online Documentation for SQL Manager for SQL server

Specifying FileTable options


Use the FileTable Options tab to configure settings for the FileTable being created.

This tab is available only for SQL Server 2012.

The fields on this tab are enabled only if the CheckBox File table option is checked on the Table tab.

 

New table - Specifying filetable options

 

 

FileTable directory name

Specifies the windows-compatible FileTable directory name. This name should be unique among all the FileTable directory names in the database. If this value is not specified, the name of the filetable is used.

 

Collation of the Name column

Select the name of the collation to be applied to the Name column in the FileTable. If this value is not specified, the database default collation is used.

 

Primary key constraint name

Set the name to be used for the primary key constraint that is automatically created on the FileTable. If this value is not specified, the system generates a name for the constraint.

 

stream_id unique key constraint name

Define the name to be used for the unique constraint that is automatically created on the stream_id column in the FileTable. If this value is not specified, the system generates a name for the constraint.

 

Full path unique key constraint name

Specify the name to be used for the unique constraint that is automatically created on the parent_path_locator and name columns in the FileTable. If this value is not specified, the system generates a name for the constraint.