Use SQL INSERT to Create Directories with FileTable

Question

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

This is my first experience with SQL Server 2012 and I'm not familiar with the limits of the FileTable from within SQL Server.

SliverNinja · Accepted Answer · 2012-05-10 18:59:32Z

7

The following worked for me. Hopefully this helps out someone else.

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

You should also check out Bob Beauchemin's Techdays 2012 video for more details on FileStream and its evolution into FileTable.

edited May 10, 2012 at 18:59

answered May 7, 2012 at 16:13

SliverNinja

31.7k13 gold badges121 silver badges183 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Rhyous Over a year ago

This is partially right. This only covers adding a directory in the root. Adding a subdirectory, or creating a path without any of the parent directories created, are not handled by this.

SliverNinja Over a year ago

@Rhyous - you are correct, for adding subdirectories see this related SO post. You must have a parent defined before you can create any children. You could implement a simple algorithm to do the behavior you are seeking using a combination of this post and the other and checking whether a given directory exists already.

Rhyous Over a year ago

Thanks. Found that yesterday. I am taking this and making some SQL functions. Maybe I'll share them on GitHub when I am done.

Collectives™ on Stack Overflow

Use SQL INSERT to Create Directories with FileTable

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related