on 01-13-2015 2:58 PM
Hi,
I would need to get sure, I'm not doing anything wrong.
We have a simple HANA table with one unique index on it:
Now, we are generating the DDL script for this table... the code for creation of the index gets generated.. but it's not a unique index anymore...
Am I doing something wrong, or is it a bug?
Thanks,
Rafal
Hi Rafal
i dont know if its a bug or a feature
but here is the fix:
Please Backup the file Hanadb10.xdb before doing this quickfix!
go to Database>Edit current dbms
locate to SAPHANA10::Script\Objects\Index\Create
you will see:
.if (%Parent.isCatalogTable%==true)
create[ %INDEXTYPE%] index %INDEX% on [%TABLQUALIFIER%]%TABLE% (%CIDXLIST%)[%DescIndex%? desc]
.endif
in the value window
change it like this:
.if (%Parent.isCatalogTable%==true)
create[ %UNIQUE%][ %INDEXTYPE%] index %INDEX% on [%TABLQUALIFIER%]%TABLE% (%CIDXLIST%)[%DescIndex%? desc]
.endif
Please Backup the file Hanadb10.xdb before doing this quickfix!
HTH
dj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.