Drop Filestream In SQL Server

I have a table in SQL Server where one column is placed in Filestream filegroup. Now I need to delete this column and all files on disk.
Just recall the process to implement Filestream in SQL Server database:

  1. Add Filestream filegroup;
  2. Add file to a newly created Filestream filegroup;
  3. Create table where column is marked as FILESTREAM and you pointed FILESTREAM_ON to a Filestream group.

To drop Filestream you need to implement these steps in reverse order, but check Filestream columns, files and filegroups before.

Then do the following:

Leave a Reply

Your email address will not be published. Required fields are marked *