DBTools Software - Forums

Anonymous

Home » Forums » DBManager General

Why must Auto Incremental-Field be Primary Key??? (1402 previews)
Why must Auto Incremental-Field be Primary Key???	Posted in 30th, 11/2005 06:37 by e.falkenstein
When i try to set my Primary Key (combined over 2 fields) the DBManager always delete it and set the PK to my first field ("ID") which is "Auto Incremental". Is there a reason for that strange phenomenon or is it a bug? thx a lot Eugen /
Re: Why must Auto Incremental-Field be Primary Key???	Posted in 01th, 12/2005 09:03 by support
Eugen, That depends on the database server you are using and you didn't specify that, so it's hard to guess. See that this is MySQL default behaviour as it requires that auto_increment fields are defined as PRIMARY KEY. Even if you create an auto_increment fields without specifying PRIMARY KEY it will silently do it. Other engines may not have this problem. Best Regards, Support / DBTools Software
Why must Auto Incremental-Field be Primary Key??? (1402 previews)

Legends

Topic has Replies

Topic With no Replies

Home » Forums » DBManager General