Enable/Disable Filetable(s)

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you build and submit an ALTER TABLE statement, specifying either an ENABLE FILETABLE_NAMESPACE or DISABLE FILETABLE_NAMESPACE argument. This enables or disables system-defined constraints on a FileTable.

Platform Availability

To enable or disable system-defined constraints on a FileTable

  1. Initiate an Enable/Disable Filetables action against one or more tables. For more information see Initiating an object operation.
    The Enable/Disable Filetable(s) dialog box opens.
  2. Use the following table as a guide to understanding and modifying settings in the dialog:
Step Settings and tasks

Action options

Enabled

If selected, an ALTER TABLE with an ENABLE FILETABLE_NAMESPACE argument is generated. If unselected, an ALTER TABLE with a DISABLE FILETABLE_NAMESPACE argument is generated.

Dependencies

Lets you review the objects potentially impacted by this action. For more information, see Dependencies.

Preview

Preview the DDL generated for the operation and when ready, use the Schedule or Execute button to perform this action.

3. Finally, use the Execute button to create the object.

For information on setup of filegroups, FileTable, and Filestream, see the following topics: