Use SQL INSERT to create directories using FileTable

Question

Is there a way to create directories in FileTable without using the I / O APIs? Is it as simple as creating an SQL INSERT statement?

This is my first experience with SQL Server 2012, and I am not familiar with the limitations of FileTable from within SQL Server.

Answer 1

The following worked for me. Hope this helps someone else.

 INSERT INTO FileTable0 (name,is_directory,is_archive) VALUES ('Directory', 1, 0); 

• You can also browse Bob Beauchemin Techdays 2012 for more details on FileStream and its evolution in FileTable .