cancel
Showing results for 
Search instead for 
Did you mean: 

Check constraint in HANA Support question

Former Member
0 Kudos

Hi,

My Question is Which Version of HANA support check constraint? please do not reject the post. I did research that HANA SP12 has said support check constraint, but I could not make it.

My Query like:

create column table awei.tmp_table(

type1 varchar2(20) not null,

subtype1 varchar2(20),

constraint constraint valid_type CHECK (type1 like '%Tools%')

);

and version "1.00.112.04.1467296086"

Please help.

Thanks,

Allan

Accepted Solutions (0)

Answers (1)

Answers (1)

pfefferf
Active Contributor
0 Kudos

Yes, check constraints were introduced with SPS12.

But because you are on SPS11 (1.00.112.x), you cannot use it on your system.

Also your statement would fail, cause you used two times the keyword "constraint" in it. Another thing is that the LIKE predicate is not supported for check constraints in SPS12. Only Comparison Predicates predicates are supported.

Regards,

Florian