When connecting to a database via a generic API like ODBC, JDBC, ADO,
Base currently applies a heuristics to determine whether or not this
database supports primary keys, because none of those APIs has
dedicated support to retrieve this information. Depending on the
Since the heuristics sometimes fails, there's now an explicit option
(Edit / Database / Advanced Settings) named "Supports primary keys".
It's implemented as a usual tri-state check box, where un/check mean
"do (not) assume PK support", and the "undetermined" third state,
which is the default, means "apply the heuristics".
Note that if this option is just for overruling the heuristics. If you
check it for a database which actually does not support primary keys,
you'll probably be slain with error messages as soon as Base attempts
to actually use PK related features (like creating a PK in the table