Note Varchar(max), nvarchar(max), varbinary(max), xml and large UDT values are stored directly in the data row, up to a limit of 8000 bytes and as long as the value can fit the record.If the value does not fit in the record, a pointer is sorted in-row and the rest is stored out of row in the LOB storage space. TEXTIMAGE_ON only changes the location of the "LOB storage space", it does not affect when data is stored in-row.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.--Disk-Based CREATE TABLE Syntax CREATE TABLE [ database_name . For more information about File Tables, see File Tables (SQL Server). ] table_name [ AS File Table ] ( [ ,...n ] [ PERIOD FOR SYSTEM_TIME ( system_start_time_column_name , system_end_time_column_name ) ] ) [ ON ] [ TEXTIMAGE_ON ] [ FILESTREAM_ON ] [ WITH ( [ FILESTREAM ] [ COLLATE collation_name ] [ SPARSE ] [ MASKED WITH ( FUNCTION = ' mask_function ') ] [ CONSTRAINT constraint_name [ DEFAULT constant_expression ] ] [ IDENTITY [ ( seed,increment ) ] [ NOT FOR REPLICATION ] [ GENERATED ALWAYS AS ROW [ HIDDEN ] ] [ NULL | NOT NULL ] [ ROWGUIDCOL ] [ ENCRYPTED WITH ( COLUMN_ENCRYPTION_KEY = key_name , ENCRYPTION_TYPE = , ALGORITHM = ' AEAD_AES_256_CBC_HMAC_SHA_256' ) ] [ [ , ...n ] ) ] [ ON ] | [ FOREIGN KEY ] REFERENCES referenced_table_name [ ( ref_column ) ] [ ON DELETE ] [ ON UPDATE ] [ NOT FOR REPLICATION ] | CHECK [ NOT FOR REPLICATION ] ( logical_expression ) ] [ , ...n ] ) ] [ ON ] | FOREIGN KEY ( column [ ,...n ] ) REFERENCES referenced_table_name [ ( ref_column [ ,...n ] ) ] [ ON DELETE ] [ ON UPDATE ] [ NOT FOR REPLICATION ] | CHECK [ NOT FOR REPLICATION ] ( logical_expression ) --Memory optimized CREATE TABLE Syntax CREATE TABLE [database_name . AS File Table Applies to: SQL Server 2012 through SQL Server 2017. You do not specify columns because a File Table has a fixed schema.
If "default" is specified, the QUOTED_IDENTIFIER option must be ON for the current session. For more information, see SET QUOTED_IDENTIFIER (Transact-SQL).
For example, a computed column can have the definition: cost AS price * qty.
The expression can be a noncomputed column name, constant, function, variable, and any combination of these connected by one or more operators.
TEXTIMAGE_ON is not allowed if there are no large value columns in the table. If "default" is specified, or if TEXTIMAGE_ON is not specified at all, the large value columns are stored in the default filegroup.
The storage of any large value column data specified in CREATE TABLE cannot be subsequently altered.