QUA_PARTITION_HINT#
Loads partitioning information. Should be used as a constraint of a table.
Syntax#
QUA_PARTITION_HINT ( mode, definition_json )
Arguments#
mode
Is a string literal which defines a mode of partitioning.
definition_json
Specifies a definition provided as JSON string literal. The definition_json has to be in line with mode.
Return types#
The result is a type of bit but the result value can’t be consumed in any way.
Example#
CREATE TABLE BigTable (
user_id bigint,
firstname nvarchar(50),
lastname nvarchar(50),
nationality nvarchar(50),
constraint CHK_table_partition_hint check ( qua_partition_hint ('create_table_columns', '{ "columns": ["nationality"]}') = 1 )
);
See also: