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.

See Also

Create, Alter, and Drop FileTables