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.
SQL Server FILESTREAM makes file handling efficient and secure. To read more ...