How to create a FILESTREAM col in GUI

• ahmed_b72

  Ten Centuries

  Points: 1251

  More actions

  September 7, 2011 at 9:45 pm

  #256809

  Hi,

  I've successfully created a column of type VARBINARY(MAX) with FILESTREAM property using ALTER TABLE .. ADD command.

  My question is: how can I make it using the GUI SQL Server Management Studio?

  When I right clicked on a table and selected "Design", I couldn't find a way to set the FILESTREAM property for a column.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738803

  More actions

  September 8, 2011 at 8:45 am

  #1378606

  There's no GUI support right now.

  Make sure you've created the filestream filegroup first, then you can set this in the T-SQL for the table.