list out the columns and tables which has FILESTREAM option

Professionaluser
Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 199
-- To list out FILESTREAM related columns
SELECT s.name + '.' + o.name TableName, c.name 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