If you omit the WITH SCHEMA clause in the CREATE or ALTER TABLE statement, the DATASET value is defined with an instance-level schema. The schema and data are stored in the database row. This allows a DATASET table column to contain data values with different schemas. This flexibility comes at the cost of increased storage usage and reduced performance due to schema parsing.
The following shows an instance-level schema for a DATASET value with the CSV storage format:
CreateDATASET
(
'{"field_delimiter":"&", "record_delimiter":"#" }',
'Item ID&Item Name&Item Color #55&bicycle&red#88&toy boat&pink#105&soap&#',
CSV,
UNICODE
)