FileTable Schema
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 |
bit not 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 |
bit not null |
1 byte |
FALSE |
Offline file attribute. |
Calculated automatically. Can also be set by using Windows APIs. |
is_hidden |
bit not null |
1 byte |
FALSE |
Hidden file attribute. |
Calculated automatically. Can also be set by using Windows APIs. |
is_readonly |
bit not null |
1 byte |
FALSE |
Read-only file attribute. |
Calculated automatically. Can also be set by using Windows APIs. |
is_archive |
bit not null |
1 byte |
FALSE |
Archive attribute. |
Calculated automatically. Can also be set by using Windows APIs. |
is_system |
bit not null |
1 byte |
FALSE |
System file attribute. |
Calculated automatically. Can also be set by using Windows APIs. |
is_temporary |
bit not null |
1 byte |
FALSE |
Temporary file attribute. |
Calculated automatically. Can also be set by using Windows APIs. |