Am 21.05.2015 um 09:25 schrieb Hick Gunter: > alter table [database] add column [real_length] numeric; Thanks, that did it right. Almost. Still I'm wondering why the output is not as "smooth" as the .fullschema listing before the ALTER ADD COLUMN: (comma at line start, lower case 'numeric')
sqlite> .fullschema CREATE TABLE [database] ( [database_name] TEXT NULL, [table_name] TEXT NULL, [data_type] TEXT NULL, [data_size] INTEGER NULL, [column_name] TEXT NULL, [vendor] TEXT DEFAULT 'SQLBASE' NULL ); /* No STAT tables available */ sqlite> alter table [database] add column [real_length] numeric; sqlite> .fullschema CREATE TABLE [database] ( [database_name] TEXT NULL, [table_name] TEXT NULL, [data_type] TEXT NULL, [data_size] INTEGER NULL, [column_name] TEXT NULL, [vendor] TEXT DEFAULT 'SQLBASE' NULL , [real_length] numeric); /* No STAT tables available */ -- Christoph Kukulies