FileTables in SQL Server 2012

Hi All,

FileTables feature introduced in SQL Server 2012. This feature is built on the top of FileStream feature of SQL Server 2012. I published the introduction of FileStream in my previous post.

FileTables allows us to store files and documents in special tables in SQL Server called FileTables, but access them from Windows applications as if they were stored in the file system, without making any changes to your client applications.

A FileTable is a specialized user table with a pre-defined schema that stores FILESTREAM data, as well as file and directory hierarchy information and file attributes.

You can find the detailed list of features/functionalities here:

You can also check the table schema details here:

Thanks, Khilit

Rate this post

Leave a Reply