FileTable DDL, Functions, Stored Procedures, and Views

 

Applies To: SQL Server 2016

Lists the Transact-SQL statements and the SQL Server database objects that have been added or changed to support the FileTable feature in SQL Server.

The Status column in the following tables indicates whether the item is new in SQL Server 2012, or was present in previous versions of SQL Server but has been changed in SQL Server 2012 to support semantic search.

For the list of statements and database objects that support FILESTREAM, see FILESTREAM DDL, Functions, Stored Procedures, and Views.

ObjectStatusMore Information
ALTER DATABASE (Transact-SQL)

 ALTER DATABASE SET Options (Transact-SQL)
ChangedEnable the Prerequisites for FileTable

 Manage FileTables
ALTER TABLE (Transact-SQL)ChangedCreate, Alter, and Drop FileTables

 Manage FileTables
CREATE DATABASE (SQL Server Transact-SQL)ChangedEnable the Prerequisites for FileTable
CREATE TABLE (Transact-SQL)ChangedCreate, Alter, and Drop FileTables
RESTORE (Transact-SQL)

 RESTORE Arguments (Transact-SQL)
Changed
ObjectStatusMore Information
FileTableRootPath (Transact-SQL)AddedWork with Directories and Paths in FileTables
GetFileNamespacePath (Transact-SQL)AddedWork with Directories and Paths in FileTables
GetPathLocator (Transact-SQL)AddedWork with Directories and Paths in FileTables
ObjectStatusMore Information
sp_kill_filestream_non_transacted_handles (Transact-SQL)AddedManage FileTables
ObjectStatusMore Information
sys.database_filestream_options (Transact-SQL)AddedEnable the Prerequisites for FileTable
sys.filetable_system_defined_objects (Transact-SQL)AddedCreate, Alter, and Drop FileTables

 Manage FileTables
sys.filetables (Transact-SQL)AddedManage FileTables
sys.tables (Transact-SQL)ChangedManage FileTables
ObjectStatusMore Information
sys.dm_filestream_non_transacted_handles (Transact-SQL)AddedManage FileTables

Manage FileTables

Community Additions

ADD
Show: