FileTable DDL, functions, stored procedures, and views

Applies to: SQL Server

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 (11.x), or was present in previous versions of SQL Server but has been changed in SQL Server 2012 (11.x) to support semantic search.

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

Transact-SQL Data Definition Language (DDL) Statements

Object Status More Information
ALTER DATABASE (Transact-SQL)

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

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

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

RESTORE Arguments (Transact-SQL)
Changed

Functions

Object Status More Information
FileTableRootPath (Transact-SQL) Added Work with Directories and Paths in FileTables
GetFileNamespacePath (Transact-SQL) Added Work with Directories and Paths in FileTables
GetPathLocator (Transact-SQL) Added Work with Directories and Paths in FileTables

Stored Procedures

Object Status More Information
sp_kill_filestream_non_transacted_handles (Transact-SQL) Added Manage FileTables

Catalog Views

Object Status More Information
sys.database_filestream_options (Transact-SQL) Added Enable the Prerequisites for FileTable
sys.filetable_system_defined_objects (Transact-SQL) Added Create, Alter, and Drop FileTables

Manage FileTables
sys.filetables (Transact-SQL) Added Manage FileTables
sys.tables (Transact-SQL) Changed Manage FileTables

Dynamic Management Views

Object Status More Information
sys.dm_filestream_non_transacted_handles (Transact-SQL) Added Manage FileTables

See Also

Manage FileTables