Re: [sqlite] Tidy Up Schema

2005-05-03 Thread Eric Scouten
Murray Moffatt wrote: I would like to tidy up the schema's of a few tables. At the moment all of the fields run together on the same line, i.e. something like this: sqlite> .schema materials CREATE TABLE Materials (MaterialType varchar(10) not null, MaterialCode varchar( 10) not null, Descript

[sqlite] Tidy Up Schema

2005-05-03 Thread Murray Moffatt
I would like to tidy up the schema's of a few tables. At the moment all of the fields run together on the same line, i.e. something like this: sqlite> .schema materials CREATE TABLE Materials (MaterialType varchar(10) not null, MaterialCode varchar( 10) not null, Description varchar(50),Quantit