O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required