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_COLLATE_FILENAME), but they are not required.