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.

In This Topic

• Transact-SQL Data Definition Language (DDL) Statements

• Functions

• Stored Procedures

• Catalog Views

• Dynamic Management Views

• Programming APIs

Transact-SQL Data Definition Language (DDL) Statements

• 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]

System Functions

• GET_FILESTREAM_TRANSACTION_CONTEXT (Transact-SQL)

• PathName (Transact-SQL)

[TOP]

System Stored Procedures

• sp_configure (Transact-SQL)

• sp_filestream_force_garbage_collection (Transact-SQL)

[TOP]

System Views – Catalog Views

• sys.database_filestream_options (Transact-SQL)

[TOP]

System Views – Dynamic Management Views

• sys.dm_filestream_file_io_handles (Transact-SQL)

• sys.dm_filestream_file_io_requests (Transact-SQL)

[TOP]

Programming APIs

• Access FILESTREAM Data with OpenSqlFilestream

• Managed API - SqlFileStream Class