FILESTREAM, functions, stored procedures, and views

Applies to: SQL Server

Lists the Transact-SQL statements and the SQL Server database objects that support FILESTREAM.

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

Transact-SQL Data Definition Language (DDL) Statements

• CREATE DATABASE (SQL Server Transact-SQL)

• ALTER DATABASE (Transact-SQL)

• CREATE TABLE (Transact-SQL)

• ALTER TABLE (Transact-SQL)

• CREATE INDEX (Transact-SQL)

• DROP INDEX (Transact-SQL)

System Functions

• GET_FILESTREAM_TRANSACTION_CONTEXT (Transact-SQL)

• PathName (Transact-SQL)

System Stored Procedures

• sp_configure (Transact-SQL)

• sp_filestream_force_garbage_collection (Transact-SQL)

System Views - Catalog Views

• sys.database_filestream_options (Transact-SQL)

System Views - Dynamic Management Views

• sys.dm_filestream_file_io_handles (Transact-SQL)

• sys.dm_filestream_file_io_requests (Transact-SQL)

Programming APIs

• Access FILESTREAM Data with OpenSqlFilestream

• Managed API - SqlFileStream Class