SQL Power Software Forum

castorp wrote:That the primary key is enforeced through a constraint is a technical detail. A DBMS is free on how it enforeces that, it does not need to use a constraint for that.

It would be best to clarify what "primary key" is referring to in the UI. As you point out, we can't assume that this is the name of a constraint.

The lack of datatype may be interpreted as an effort to provide a shortcut that ensures the presence of a primary key, but not a replacement for the column-properties UI.

I haven't encountered this ambiguity with other DB-design tools (Data ERWin, ERStudio, SQL Editor).

Thanks for the info.

Ah, so the real problem is that there's a word ("constraint") missing from the UI.

Thanks for the info.

Thanks for your reply, Benjamin.

No, moving the non-key column to the top doesn't make it disappear. It simply moves above the tiny blank row in the diagram. So the drawing problem appears to be specific to key columns.

Nobody? Because of this and the key columns not being shown in the diagram, I've had to go back to SQL Editor.

Benjamin wrote:You create a new table with a primary key and the primary key column doesn't show up?

Right.

Benjamin wrote:Are you using Mac OS?

Yep. 10.6.2.

Here's the screen shot:

Thanks for any insight.