Move a Filestream column between tables I have a table which has a Filestream column which I would like to move to another table.

Is this possible without having to do a "manual" move of the data (create target column; issue UPDATE/INSERT to target column from source column; DELETE source column)?

I'm hoping there might be a way to simply "detach" the column and move it to a different table.

I found a similar/related question about altering Filestream tables which makes me think that it isn't possible, but hoping that someone might be able to help!
You can't move the column without copying the data. There's one rather exotic idea to pull this of: You move all other columns and leave the filestream column in place.

Depending on the number of rows and schema changes required this can be a lot faster (or slower). You might have to completely gut some tables and create complicated scripts. I only would do this approach if you really need to avoid this downtime.