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
-- 
View this message in context: 
http://www.nabble.com/id-INTEGER-PRIMARY-KEY--vs--PRIMARY-KEY-%28id%29-----tf1922943.html#a5265104
Sent from the SQLite forum at Nabble.com.

Reply via email to