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.
Transact-SQL Data Definition Language (DDL) Statements
|sp_kill_filestream_non_transacted_handles (Transact-SQL)||Added||Manage FileTables|
Dynamic Management Views
|sys.dm_filestream_non_transacted_handles (Transact-SQL)||Added||Manage FileTables|