Re: [sqlite] id INTEGER PRIMARY KEY vs PRIMARY KEY (id) ???

Thank you very much for clearing my doubt. Rohit. -- View this message in context: http://www.nabble.com/id-INTEGER-PRIMARY-KEY--vs--PRIMARY-KEY-%28id%29-tf1922943.html#a5285302 Sent from the SQLite forum at Nabble.com.

Re: [sqlite] id INTEGER PRIMARY KEY vs PRIMARY KEY (id) ???

yup --- John Stanton <[EMAIL PROTECTED]> wrote: > A simple program which uses the API will give you > the defined type and > the actual storage format selected by Sqlite. That > would leave you in > no doubt. > > RohitPatel wrote: > > Hi SQLite users, > > > > In SQLite3 (3.3.4), > > >

Re: [sqlite] id INTEGER PRIMARY KEY vs PRIMARY KEY (id) ???

RohitPatel <[EMAIL PROTECTED]> wrote: > Hi SQLite users, > > In SQLite3 (3.3.4), > > Will both of the following statements create same tables ? > 'id' column will be internally same or different ? > > create table t1 > ( > id INTEGER PRIMARY KEY, > name CHAR(20) > ); > > create table

[sqlite] id INTEGER PRIMARY KEY vs PRIMARY KEY (id) ???

Hi SQLite users, In SQLite3 (3.3.4), Will both of the following statements create same tables ? 'id' column will be internally same or different ? create table t1 ( id INTEGER PRIMARY KEY, name CHAR(20) ); create table t1 ( id INTEGER, name CHAR(20), PRIMARY KEY (id) ); What I