FILESTREAM DDL, 함수, 저장 프로시저 및 뷰FILESTREAM DDL, Functions, Stored Procedures, and Views

FILESTREAM을 지원하는 Transact-SQL 문 및 SQL ServerSQL Server 데이터베이스 개체를 나열합니다.Lists the Transact-SQL statements and the SQL ServerSQL Server database objects that support FILESTREAM.

FileTable 기능을 지원하는 데이터베이스 개체 목록은 FileTable DDL, Functions, Stored Procedures, and Views를 참조하세요.For the list of database objects that support the FileTable feature, see FileTable DDL, Functions, Stored Procedures, and Views.

Transact-SQL DDL(데이터 정의 언어) 문 Transact-SQL Data Definition Language (DDL) Statements

• CREATE DATABASE(SQL Server Transact-SQL)CREATE DATABASE (SQL Server Transact-SQL)

• ALTER DATABASE(Transact-SQL)ALTER DATABASE (Transact-SQL)

• CREATE TABLE(Transact-SQL)CREATE TABLE (Transact-SQL)

• ALTER TABLE(Transact-SQL)ALTER TABLE (Transact-SQL)

• CREATE INDEX(Transact-SQL)CREATE INDEX (Transact-SQL)

• DROP INDEX(Transact-SQL)DROP INDEXDROP INDEX (Transact-SQL)DROP INDEX

시스템 함수 System Functions

• GET_FILESTREAM_TRANSACTION_CONTEXT(Transact-SQL)GET_FILESTREAM_TRANSACTION_CONTEXT (Transact-SQL)

• PathName(Transact-SQL)PathName (Transact-SQL)

시스템 저장 프로시저 System Stored Procedures

• sp_configure (Transact-SQL)sp_configure (Transact-SQL)

• sp_filestream_force_garbage_collection(Transact-SQL)sp_filestream_force_garbage_collection (Transact-SQL)

시스템 뷰 - 카탈로그 뷰 System Views – Catalog Views

• sys.database_filestream_options(Transact-SQL)sys.database_filestream_options (Transact-SQL)

시스템 뷰 - 동적 관리 뷰 System Views – Dynamic Management Views

• sys.dm_filestream_file_io_handles(Transact-SQL)sys.dm_filestream_file_io_handles (Transact-SQL)

• sys.dm_filestream_file_io_requests(Transact-SQL)sys.dm_filestream_file_io_requests (Transact-SQL)

프로그래밍 API Programming APIs

• OpenSqlFilestream을 사용하여 FILESTREAM 데이터 액세스Access FILESTREAM Data with OpenSqlFilestream

• 관리되는 API - SqlFileStream 클래스Managed API - SqlFileStream Class