Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Describes the pre-defined and fixed schema of a FileTable.
| File attribute name | type | Size | Default | Description | File system accessibility |
|---|---|---|---|---|---|
| path_locator | hierarchyid |
variable | A hierarchyid that identifies the position of this item. |
The position of this node in the hierarchical FileNamespace. Primary key for the table. |
Can be created and modified by setting the Windows path values. |
| stream_id | [uniqueidentifier] rowguidcol | A value returned by the NEWID() function. |
A unique ID for the FILESTREAM data. | Not applicable. | |
| file_stream | varbinary(max)filestream |
variable | NULL | Contains the FILESTREAM data. | Not applicable. |
| file_type | nvarchar(255) |
variable | NULL. A create or rename operation in the file system populates the file extension value from the name. |
Represents the type of the file. This column can be used as the TYPE COLUMN when you create a full-text index.file_type is a persisted computed column. |
Calculated automatically. Cannot be set. |
| Name | nvarchar(255) |
variable | GUID value. | The file or directory name. | Can be created or modified by using Windows APIs. |
| parent_path_locator | hierarchyid |
variable | A hierarchyid that identifies the directory that contains this item. |
The hierarchyid of the containing directory.parent_path_locator is a persisted computed column. |
Calculated automatically. Cannot be set. |
| cached_file_size | bigint |
The size in bytes of the FILESTREAM data. cached_file_size is a persisted computed column. |
Although the cached file size is automatically kept up to date, it can go out of sync in unusual circumstances. To calculate the exact size, use the DATALENGTH() function. |
||
| creation_time | datetime2(4)not null |
8 bytes | Current time. | The date and time that the file was created. | Calculated automatically. Can also be set by using Windows APIs. |
| last_write_time | datetime2(4)not null |
8 bytes | Current time. | The date and time that the file was last updated. | Calculated automatically. Can also be set by using Windows APIs. |
| last_access_time | datetime2(4)not null |
8 bytes | Current time. | The date and time that the file was last accessed. | Calculated automatically. Can also be set by using Windows APIs. |
| is_directory | bitnot null |
1 byte | FALSE | Indicates whether the row represents a directory. This value is calculated automatically, and cannot be set. | Calculated automatically. Cannot be set. |
| is_offline | bitnot null |
1 byte | FALSE | Offline file attribute. | Calculated automatically. Can also be set by using Windows APIs. |
| is_hidden | bitnot null |
1 byte | FALSE | Hidden file attribute. | Calculated automatically. Can also be set by using Windows APIs. |
| is_readonly | bitnot null |
1 byte | FALSE | Read-only file attribute. | Calculated automatically. Can also be set by using Windows APIs. |
| is_archive | bitnot null |
1 byte | FALSE | Archive attribute. | Calculated automatically. Can also be set by using Windows APIs. |
| is_system | bitnot null |
1 byte | FALSE | System file attribute. | Calculated automatically. Can also be set by using Windows APIs. |
| is_temporary | bitnot null |
1 byte | FALSE | Temporary file attribute. | Calculated automatically. Can also be set by using Windows APIs. |