Export (0) Print
Expand All

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.

Community Additions

ADD
Show:
© 2014 Microsoft