title: How to make a FileTable folder name change reflected in Windows Explorer?
body: <p>I have a <code>FileTable</code> in my SQL Server 2012 database, which contains both folders and files. I wanted to rename a folder, so I executed</p>
  
  <p><code>update MyFileTable set name = 'NewName' where name = 'OldName';</code></p>
  
  <p>The update was successful, and the file table reflects the new name when I select from it. However, when I go into Windows Explorer and navigate to the corresponding folder location, the new name is not reflected. I tried refreshing and waiting a bit, then refreshing, but the folder still has the old name. When I attempt to open the folder (with the old name) it gives an error that the location is not valid (or something to that effect), and, after clicking "OK", the folder disappears.</p>
  
  <p>However, if I try to create a new folder in the same location with the new name, I get an error that the folder already exists. When I click "OK", the folder with the new name appears, plus a new folder with name "New folder" (due to the unsuccessful attempt to create the folder with a name of <code>NewName</code>. After deleting the folder <code>New folder</code>, I have the desired result: the file table is updated and the new name is reflected in Windows Explorer.</p>
  
  <p>So, it seems the file table is working for the most part, but how can I make sure a name change (or other change) carried out in a query or stored procedure will be reflected in the file share?</p>
  
  <p>I have googled around but have not found anything that discusses this issue.</p>
  
  <p>EDIT:<br/>I have noticed a similar thing when inserting new records into the file table. The new records (folders in this case) do not show up in Windows Explorer after creation, even though they do appear in the file table. Curiously, however, after trying different things, five recently created folders appeared in Windows Explorer all at once. So, maybe there's just a lag. Has anyone had a similar experience?</p>