Re: [sqlite] Order of columns within a CREATE TABLE statement

2006-07-20 Thread w b
Christian, Thanks for the helpful insight on this. I'll readjust my tables as required. Thanks again Wayne Christian Smith <[EMAIL PROTECTED]> wrote: w b uttered: > > Hi all, > > Just had a quick question with regards to the order of the columns > within a create table statement >

Re: [sqlite] Order of columns within a CREATE TABLE statement

2006-07-20 Thread Christian Smith
w b uttered: Hi all, Just had a quick question with regards to the order of the columns within a create table statement I have a few tables that use the BLOB type for storing various lengths of binary data and I was wondering if its better (more efficient) to always declare columns of this ty

[sqlite] Order of columns within a CREATE TABLE statement

2006-07-19 Thread w b
Hi all, Just had a quick question with regards to the order of the columns within a create table statement I have a few tables that use the BLOB type for storing various lengths of binary data and I was wondering if its better (more efficient) to always declare columns of this type last withi