O'Reilly logo

What's New in SQL Server 2012 by Jon Reade, Rachel Clements

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

FileTable table type

FileTable is a new type of table which builds on the existing FILESTREAM functionality that was introduced in SQL Server 2008. FILESTREAM is an efficient way to store documents inside the database, as they are managed by SQL Server and included in any backups. You can store any type of file and up to any size—the only limit is the size of the disk the FILESTREAM store sits on.

FILESTREAM effectively manages the files you insert, whereas FileTable will allow access through Windows to the properties of files stored on the NT file system. In effect, FileTable really is a table of files. This is where it becomes exciting, as you are about to discover.

Tip

SQL Server FILESTREAM makes file handling efficient and secure. To read more ...

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