--Disk-Based CREATE TABLE Syntax CREATE TABLE [ database_name . For more information about File Tables, see File Tables (SQL Server).
Is an expression that defines the value of a computed column.
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 column is computed from an expression that uses other columns in the same table.An expression that is nullable can be turned into a nonnullable one by specifying ISNULL with the constant, where the constant is a nonnull value substituted for any NULL result.REFERENCES permission on the type is required for computed columns based on common language runtime (CLR) user-defined type expressions.If the PRIMARY KEY or UNIQUE constraint creates a clustered index, the data pages for the table are stored in the same filegroup as the index.If CLUSTERED is specified or the constraint otherwise creates a clustered index, and a Note In this context, default is not a keyword.is specified, the table is stored in the named filegroup. If "default" is specified, or if ON is not specified at all, the table is stored on the default filegroup.The storage mechanism of a table as specified in CREATE TABLE cannot be subsequently altered.For more information, see Indexes on Computed Columns.Any computed columns that are used as partitioning columns of a partitioned table must be explicitly marked PERSISTED.PERSISTED Specifies that the SQL Server Database Engine will physically store the computed values in the table, and update the values when any other columns on which the computed column depends are updated.Marking a computed column as PERSISTED lets you create an index on a computed column that is deterministic, but not precise.