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: