Introduction Of FileTable in SQL Server 2012

In this article I describe about a new feature introduced in SQL Server 2012 i.e FileTable.
  • 3538

Introduction

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.

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

  1. Its each row represents a file or a directory.
  2. FileTable stores directory structure and file attributes.
  3. The data stored in File Table  is exposed to windows through windows share as it supports WIN32APIs.

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.