Filestream and FileTable system stored procedures (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

This section describes the system stored procedures to the FileTable and Filestream feature.

Filestream and Filetable system stored procedures

sp_filestream_force_garbage_collection (Transact-SQL)

Forces the FILESTREAM garbage collector to run, deleting any unneeded FILESTREAM files.

sp_kill_filestream_non_transacted_handles (Transact-SQL)

Closes non-transactional file handles to FileTable data.

See also

Filestream and FileTable Dynamic Management Views (Transact-SQL)
Filestream and FileTable Catalog Views (Transact-SQL)