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. > > 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 > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com