Microsoft® SQL Server 2012 Unleashed

Creating FileTables

FileTables can be created using SSMS or T-SQL. To create one using SSMS, you right-click on the Tables node in the Object Explorer and select New FileTable. This opens up a query window with a template script that you can modify with the FileTable specifics. The following example shows an example of creating the FileTable directly with T-SQL using the FILESTREAM filegroup created previously:

Click here to view code image

USE [AdventureWorks2012]GOCREATE TABLE FileTable1 AS FILETABLEGO

It is as simple as that. There are additional parameters that you can also specify (such as FILETABLE_DIRECTORY and FILETABLE_COLLATE_FILENAME), but they are not required.