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

[John Stanton]

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.

RohitPatel9999 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 t1
(
  id INTEGER,
  name CHAR(20),
  PRIMARY KEY (id)
);

What I mean is, 
-> Following Both are equivalent or not ?

   id INTEGER PRIMARY KEY

     and

   id INTEGER
   PRIMARY KEY (id)


Thanks for any help or clarification. 

Rohit