You may have already thought of this but I like to start with the things I
always forget.
Is the column you are trying to create the unique index on Nullable?
-----Original Message-----
From: Hermann Himmelbauer
To: [EMAIL PROTECTED]
Sent: 9/19/2003 2:07 PM
Subject: Adding a second unique index
Hi,
Probably a simple SQL question:
I have a simple table with a unique primary index on the first column.
What I want to do is create a second unique index on another column -
but this
does not work as SAPDB gives an error - it seems to conflict with the
primary
index. When I make the index not unique, it works.
Is there any solution to this? How can I create 2 unique indices on a
table?
Best Regards,
Hermann
--
[EMAIL PROTECTED]
GPG key ID: 299893C7 (on keyservers)
FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
