Issue Details (XML | Word | Printable)

Key: NUCRDBMS-542
Type: Task Task
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Support definition of PRIMARY KEY alongside column definition in CREATE TABLE statement

Created: 02/Jul/11 06:24 PM   Updated: 03/Oct/11 07:38 AM   Resolved: 23/Aug/11 11:55 AM
Component/s: Schema
Affects Version/s: None
Fix Version/s: 3.0.1


 Description  « Hide
Some RDBMS allow you to specify the PRIMARY KEY keyword(s) in the column definition of the CREATE TABLE statement. Obviously this means you can't define the PK constraint name, but some don't allow that (e.g SQLite, which insists on PRIMARY KEY in the column definition if using AUTOINCREMENT).

Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 23/Aug/11 11:55 AM
SVN trunk now allows this, for SQLite identity column only initially