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

[drh]

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

Both tables are the same.

--
D. Richard Hipp   <[EMAIL PROTECTED]>