FILESTREAM DDL, Functions, Stored Procedures, and Views

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

• Functions

• Stored Procedures

• Catalog Views

• Dynamic Management Views

• Programming APIs

• CREATE DATABASE (Transact-SQL)

• ALTER DATABASE (Transact-SQL)

• CREATE TABLE (Transact-SQL)

• ALTER TABLE (Transact-SQL)

• CREATE INDEX (Transact-SQL)

• DROP INDEX (Transact-SQL)DROP INDEX

[TOP]

• GET_FILESTREAM_TRANSACTION_CONTEXT (Transact-SQL)

• PathName (Transact-SQL)

[TOP]

• sp_configure (Transact-SQL)

• sp_filestream_force_garbage_collection (Transact-SQL)

[TOP]

• sys.database_filestream_options (Transact-SQL)

[TOP]

• sys.dm_filestream_file_io_handles (Transact-SQL)

• sys.dm_filestream_file_io_requests (Transact-SQL)

[TOP]

• Access FILESTREAM Data with OpenSqlFilestream

• Managed API - SqlFileStream Class