FileTable DDL, Functions, Stored Procedures, and Views

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.

In This Topic

• Transact-SQL Data Definition Language (DDL) Statements

• Functions

• Stored Procedures

• Catalog Views

• Dynamic Management 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 (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

[TOP]

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

[TOP]

Stored Procedures

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

[TOP]

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

[TOP]

Dynamic Management Views

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

[TOP]

See Also

Concepts

Manage FileTables