Create a Table for Storing FILESTREAM Data

This topic shows how to create a table for storing FILESTREAM data.

When the database has a FILESTREAM filegroup, you can create or modify tables to store FILESTREAM data. To specify that a column contains FILESTREAM data, you create a varbinary(max) column and add the FILESTREAM attribute.

To create a table to store FILESTREAM data

In SQL Server Management Studio, click New Query to display the Query Editor.
Copy the Transact-SQL code from the following example into the Query Editor. This Transact-SQL code creates a FILESTREAM-enabled table called Records.
To create the table, click Execute.

Example

The following code example shows how to create a table that is named Records. The Id column is a ROWGUIDCOL column and is required to use FILESTREAM data with Win32 APIs. The SerialNumber column is a UNIQUE INTEGER. The Chart column is a FILESTREAM column and is used to store the Chart in the file system.

Note
This example refers to the Archive database that is created in Create a FILESTREAM-Enabled Database¹.

Transact-SQL

CREATE TABLE Archive.dbo.Records
(
	[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE, 
	[SerialNumber] INTEGER UNIQUE,
	[Chart] VARBINARY(MAX) FILESTREAM NULL
)
GO

Reference

CREATE TABLE (Transact-SQL)²

ALTER TABLE (Transact-SQL)³

Links Table

¹http://technet.microsoft.com/en-us/library/cc645585.aspx

²http://technet.microsoft.com/en-us/library/ms174979.aspx

³http://technet.microsoft.com/en-us/library/ms190273.aspx

Community Content Add

FAQ