O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required