I couldn’t find any straight answer after googling, so I’m gonna put it here for all of you who want to add a FileStream varbinary to an existing table.
You should already know that you can not do this from the design window of your table.
You need to do it in 3 steps:
First one is defining in which filegroup the files need to be stored. You define your filegroup on database level.
ALTER TABLE dbo.YourTable SET (FILESTREAM_ON = FileStreamGroup)
Next you create a row guid column
ALTER TABLE dbo.YourTable ALTER COLUMN GuidFieldAsPK ADD ROWGUIDCOL
Finally you add the file
ALTER TABLE dbo.YourTable ADD YourNewFileStreamField varbinary(max) FILESTREAM NOT NULL