on 09-27-2016 8:28 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.