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, 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?
If I understand correctly, all you want to do is change the stored formatting in the sqlite_master table.
If so, http://sqlite.org/faq.html#q13 applies even though you're not adding or removing columns.
-Eric
-- Eric Scouten | [EMAIL PROTECTED] | Photography: www.ericscouten.com
