sql-serverlocaldbfiletablesql-server-2016-localdb

How to create a FileTable in SQL Server LocalDb?


I installed SQL Server 2016 Express LocalDb alongside Visual Studio 2017. Googling "creating a FileTable" leads me to Enable the Prerequisites for FileTable which needs Enabling and configuring FILESTREAM.

It says:

In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.

There I stopped: I can't find any SQL Server Configuration Manager on my PC. Now the question: how to create a FileTable in SQL Server LocalDb? Is it possible to enable and configure it only with queries?

PS: you can see in Editions and supported features of SQL Server 2016 that Express edition supports FileTable.


Solution

  • Localdb does not support filetables due to security restrictions