FileTable 結構描述FileTable Schema

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

描述 FileTable 預先定義且固定的結構描述。Describes the pre-defined and fixed schema of a FileTable.

檔案屬性名稱File attribute name 型別type 大小Size 預設Default DescriptionDescription 檔案系統可存取性File system accessibility
path_locatorpath_locator hierarchyidhierarchyid 變數variable 識別此項目位置的 hierarchyidA hierarchyid that identifies the position of this item. 此節點在階層式 FileNamespace 中的位置。The position of this node in the hierarchical FileNamespace.

資料表的主索引鍵。Primary key for the table.
可透過設定 Windows 路徑值加以建立及修改。Can be created and modified by setting the Windows path values.
stream_idstream_id [uniqueidentifier] rowguidcol[uniqueidentifier] rowguidcol NEWID() 函數所傳回的值。A value returned by the NEWID() function. FILESTREAM 資料的唯一識別碼。A unique ID for the FILESTREAM data. 不適用。Not applicable.
file_streamfile_stream varbinary(max)varbinary(max)

檔案資料流filestream
變數variable NULLNULL 包含 FILESTREAM 資料。Contains the FILESTREAM data. 不適用。Not applicable.
file_typefile_type nvarchar(255)nvarchar(255) 變數variable NULL。NULL.

檔案系統中的建立或重新命名作業,將會根據名稱填入副檔名值。A create or rename operation in the file system populates the file extension value from the name.
代表檔案的類型。Represents the type of the file.

當您建立全文檢索索引時,此資料行可用以作為 TYPE COLUMNThis column can be used as the TYPE COLUMN when you create a full-text index.

file_type 是保存的計算資料行。file_type is a persisted computed column.
自動計算,Calculated automatically. 無法設定。Cannot be set.
名稱Name nvarchar(255)nvarchar(255) 變數variable GUID 值。GUID value. 檔案或目錄名稱。The file or directory name. 可使用 Windows API 加以建立或修改。Can be created or modified by using Windows APIs.
parent_path_locatorparent_path_locator hierarchyidhierarchyid 變數variable hierarchyid ,識別內含此項目的目錄。A hierarchyid that identifies the directory that contains this item. 上層目錄的 hierarchyidThe hierarchyid of the containing directory.

parent_path_locator 是保存的計算資料行。parent_path_locator is a persisted computed column.
自動計算,Calculated automatically. 無法設定。Cannot be set.
cached_file_sizecached_file_size bigintbigint FILESTREAM 資料的大小 (以位元組為單位)。The size in bytes of the FILESTREAM data.

cached_file_size 是保存的計算資料行。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. 若要計算確切的大小,請使用 DATALENGTH() 函數。To calculate the exact size, use the DATALENGTH() function.
creation_timecreation_time datetime2(4)datetime2(4)

非 Nullnot null
8 個位元組8 bytes 目前時間。Current time. 建立檔案的日期與時間。The date and time that the file was created. 自動計算,Calculated automatically. 也可以使用 Windows API 加以設定。Can also be set by using Windows APIs.
last_write_timelast_write_time datetime2(4)datetime2(4)

非 Nullnot null
8 個位元組8 bytes 目前時間。Current time. 上次更新檔案的日期與時間。The date and time that the file was last updated. 自動計算,Calculated automatically. 也可以使用 Windows API 加以設定。Can also be set by using Windows APIs.
last_access_timelast_access_time datetime2(4)datetime2(4)

非 Nullnot null
8 個位元組8 bytes 目前時間。Current time. 上次存取檔案的日期與時間。The date and time that the file was last accessed. 自動計算,Calculated automatically. 也可以使用 Windows API 加以設定。Can also be set by using Windows APIs.
is_directoryis_directory bitbit

非 Nullnot null
1 個位元組1 byte FALSEFALSE 指出資料列是否代表目錄。Indicates whether the row represents a directory. 此值會自動計算,而且無法設定。This value is calculated automatically, and cannot be set. 自動計算,Calculated automatically. 無法設定。Cannot be set.
is_offlineis_offline bitbit

非 Nullnot null
1 個位元組1 byte FALSEFALSE 離線檔案屬性。Offline file attribute. 自動計算,Calculated automatically. 也可以使用 Windows API 加以設定。Can also be set by using Windows APIs.
is_hiddenis_hidden bitbit

非 Nullnot null
1 個位元組1 byte FALSEFALSE 隱藏檔案屬性。Hidden file attribute. 自動計算,Calculated automatically. 也可以使用 Windows API 加以設定。Can also be set by using Windows APIs.
is_readonlyis_readonly bitbit

非 Nullnot null
1 個位元組1 byte FALSEFALSE 唯讀檔案屬性。Read-only file attribute. 自動計算,Calculated automatically. 也可以使用 Windows API 加以設定。Can also be set by using Windows APIs.
is_archiveis_archive bitbit

非 Nullnot null
1 個位元組1 byte FALSEFALSE 封存屬性。Archive attribute. 自動計算,Calculated automatically. 也可以使用 Windows API 加以設定。Can also be set by using Windows APIs.
is_systemis_system bitbit

非 Nullnot null
1 個位元組1 byte FALSEFALSE 系統檔案屬性。System file attribute. 自動計算,Calculated automatically. 也可以使用 Windows API 加以設定。Can also be set by using Windows APIs.
is_temporaryis_temporary bitbit

非 Nullnot null
1 個位元組1 byte FALSEFALSE 暫存檔案屬性。Temporary file attribute. 自動計算,Calculated automatically. 也可以使用 Windows API 加以設定。Can also be set by using Windows APIs.

另請參閱See Also

建立、改變及卸除 FileTableCreate, Alter, and Drop FileTables