Introduction Of FileTable in SQL Server 2012
In this article I describe about a new feature introduced in SQL Server 2012 i.e FileTable.
In this article I describe about a new feature introduced in SQL Server 2012 i.e. FileTable. SQL Server 2012 come up with new feature which allows you to store files or directories in a table called FileTable.
File Table is a new feature in SQL Server 2012 which is implemented using existing FileStream object SQL Server which was introduced in SQL Server 2008 to store unstructured data. FileTable builds on FileStream and enhances its capability. File table is a special type of table which stores files and documents that can be accessed from Windows application as they are stored in file system.
The data stored in File Table is exposed to windows through windows share. FileTable has fixed schema and each row in FileTable represents a file or directory. As Microsoft defines "FileTable lets an application integrate its storage and data management components, and provides integrated SQL Server services - including full-text search and semantic search - over unstructured data and metadata. "
Features of FileTable
- Its each row represents a file or a directory.
- FileTable stores directory structure and file attributes.
- The data stored in File Table is exposed to windows through windows share as it supports WIN32APIs.