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.
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.