Primary Key

[aedislee]

morning all

Can someone tell me how to a an AutoNumber Primary Key to a create table query please??

Thanks

 

[gemma-the-husky]

ignore post

 

[aedislee]

No I haven't tried anything

 

[ButtonMoon]

Like this:

CREATE TABLE t1 (x AUTOINCREMENT PRIMARY KEY, z String NOT NULL);