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 ...
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
