Is it true that specifying the field as primary key is not enough to create unique index on this field? Example:
the primary key _is_ unique. try EXPLAIN on a SELECT statement, or try to insert two rows with indentical primary key.
And looking in SQLStudio database object browser I can't see unique or any other index on id_city field.
SQL-Studio is/was somewhat buggy. Try to update to the latest version 7.4.3.17
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
