This filegroup is specified in the FILESTREAM_ON clause.
If the table is not partitioned and the FILESTREAM_ON clause is not specified, the FILESTREAM filegroup that has the DEFAULT property set is used.
For more information, see ALTER TABLE (Transact-SQL).
TEXTIMAGE_ON Indicates that the text, ntext, image, xml, varchar(max), nvarchar(max), varbinary(max), and CLR user-defined type columns (including geometry and geography) are stored on the specified filegroup.
The result of most expressions is considered nullable even if only nonnullable columns are present, because possible underflows or overflows also produce NULL results.
Use the COLUMNPROPERTY function with the Allows Null property to investigate the nullability of any computed column in a table.
ON can also be specified in a PRIMARY KEY or UNIQUE constraint. If is specified, the index is stored in the named filegroup.
If "default" is specified, or if ON is not specified at all, the index is stored in the same filegroup as the table.
Marking a computed column as PERSISTED lets you create an index on a computed column that is deterministic, but not precise.If the table is not partitioned, the FILESTREAM column cannot be partitioned.