list out the columns and tables which has FILESTREAM option

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 797
-- To list out FILESTREAM related columns
SELECT + '.' + TableName, ColumnName
FROM sys.columns c
INNER JOIN sys.objects o ON
o.object_id = c.object_id
INNER JOIN sys.schemas s ON
s.schema_id = o.schema_id
WHERE o.type = 'U' AND is_filestream = 1

Comments or Responses

Login to post response