Wednesday, September 25, 2019

I learned today that you cannot change the 17 columns in a FileTables table at SQL Server.

If you want to version the files, you have to make your own table for that and join to the FileTable using stream_id as the primary key in the FileTable. The 17 columns are:

  1. stream_id (uniqueidentifier, not null)
  2. file_stream (varbinary(max), null)
  3. name (nvarchar(255), not null)
  4. path_locator (PK, hierarchyid, not null)
  5. parent_path_locator (FK, Computed, hierarchyid, null)
  6. file_type (Computed, nvarchar(255), null)
  7. cached_file_size (datetimeoffset(7), not null)
  8. creation_time (datetimeoffset(7), not null)
  9. last_write_time (datetimeoffset(7), null)
  10. last_access_time (bit, not null)
  11. is_directory (bit, not null)
  12. is_offline (bit, not null)
  13. is_hidden (bit, not null)
  14. is_readonly (bit, not null)
  15. is_archive (bit, not null)
  16. is_system (bit, not null)
  17. is_temporary (bit, not null)

No comments:

Post a Comment