I'm implementing the file stream in my database for the first time and I need to write a script that is going to change the file-group of file stream in a specific table.
I was trying to work with the solutions that I found on the internet like creating a new cluster index and dropping existing but it is not working with the file-stream filegroup.
GO
Create Unique Clustered index [UQ__TblPhoto__3214EC260876E955] ON [TblPhotos] (ID asc) WITH (DROP_EXISTING=ON) ON [FileGroup-2018]
This is the code I tried.