filetable-ddl-functions-stored-procedures-and-views.md

title	FileTable functions, stored procedures, views
description	FileTable DDL, functions, stored procedures, and views
author	MikeRayMSFT
ms.author	mikeray
ms.date	12/13/2019
ms.service	sql
ms.subservice	filestream
ms.topic	concept-article
helpviewer_keywords	FileTables [SQL Server], database objects

FileTable DDL, functions, stored procedures, and views

[!INCLUDE SQL Server] Lists the [!INCLUDEtsql] statements and the [!INCLUDEssNoVersion] database objects that have been added or changed to support the FileTable feature in [!INCLUDEssNoVersion].

The Status column in the following tables indicates whether the item is new in [!INCLUDEssSQL11], or was present in previous versions of [!INCLUDEssNoVersion] but has been changed in [!INCLUDEssSQL11] 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