Microsoft® SQL Server 2012 Unleashed

Using FileTables

A FileTable is a new type of table that was added in SQL Server 2012. It builds upon and uses the SQL Server FILESTREAM technology that was introduced in SQL Server 2008. Like FILESTREAM, the FileTable provides a means for accessing and storing files in the Windows file system using SQL Server. The main difference between FILESTREAM and FileTable is that the files that are stored in a FileTable can also be accessed from Windows applications as if they were stored in the file system.

Each FileTable represents a hierarchy of files and folders located on the Windows file system. The hierarchy starts from the root node of the folder configured for the FileTable. Each row in the FileTable represents either a file or folder in the ...