Hi folks,


I would like to create a table with the « split on » option on one part of
the primary key as follow  :



CREATE TABLE IF NOT EXISTS MYTABLE ("col1 " VARCHAR NOT NULL , "col2"
VARCHAR, "col3" VARCHAR NOT NULL, "col4" VARCHAR, "col5" VARCHAR, ……
CONSTRAINT ROWKEY PRIMARY KEY ("col1", "col2")) SPLIT ON ('col1
value1','col2 value2', …… );



How can I check if my « split on » is correctly setup on my table ?



Thanks in advance for your time

Reply via email to