[sqlite] Tidy Up Schema

[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),Quantity integer default 0,Reorder 
boolean
 default 0);

What I would like them to look like is something like this:
CREATE TABLE Materials (
    MaterialType varchar(10) not null,
    MaterialCode varchar(10) not null,
    Description varchar(50),
    Quantity integer default 0,
    Reorder boolean default 0
);
The tables hold several hundred records, which I don't want to lose.  Can I 
reformat the schemas without dropping the tables and recreating them?

Regards
Murray