Enable/Disable Filetable(s)
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
- 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.
- 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: