What Is Textimage_On [Primary]?

Name: What Is Textimage_On [Primary]?
Uploaded: 2026-09-27T08:25:49+00:00
Duration: 16 min 38 s
Description: I Worked on Many Tables and All Had This Thing: Create Table Persons( [Id] [Int] Identity(1,1) Not Null, [Modified_On] [Datetime] Null, [Modified_By]...

Question

I worked on many tables and all had this thing:

CREATE TABLE Persons(
    [id] [int] IDENTITY(1,1) NOT NULL,
    [modified_on] [datetime] NULL,
    [modified_by] [varchar](200) NULL,
) 
ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

What is TEXTIMAGE_ON [PRIMARY] in SQL Server/Transact-SQL?

Accepted Answer

Given that the format is:

CREATE TABLE TableName(...) TEXTIMAGE_ON { filegroup | "default" }

TEXTIMAGE refers to all big/unlimited-size field types: text, ntext, image, xml, varchar(max), nvarchar(max), varbinary(max), and CLR user-defined type columns (including geometry and geography).

Then, you need to know what Files and FileGroups are. From the MSDN entry on Database Files and Filegroups:

Must Read

Convert File to Utf-8

How Can One Use Multi Threading in Php Applications

File

At a minimum, every SQL Server database has two operating system files: a data file and a log file. Data files contain data and objects such as tables, indexes, stored procedures, and views. Log files contain the information that is required to recover all transactions in the database. Data files can be grouped together in filegroups for allocation and administration purposes.

What Is Textimage_On [Primary]?

3 Answers

Must Read

File

James H. Sterling