Filestream allows you to store unstructured large objects (text documents, images, and videos) in the file system and have these files integrated within the database. FILESTREAM integrates the SQL Server Database Engine with New Technology File System (NTFS); it stores the data in varbinary (max) data type.

Using this data type, the unstructured data is stored in the NTFS file system, and the SQL Server Database Engine manages the link between the Filestream column and the actual file located in the NTFS. Using Transact-SQL statements users can insert, update, delete and select the data stored in FILESTREAM-enabled tables.