On 21 May 2015, at 7:51am, Christoph P.U. Kukulies <kuku at kukulies.org> wrote:
> Now I wonder why I don't read > 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; The standard of having a column name in square brackets does not belong to SQLite. It is not something SQLite does, and it is not something SQLite insists on. Whoever created the table orignally used square brackets and they worked, but that doesn't mean that everything else has to use square brackets from then on. If you like things to use square brackets do it yourself, so do alter table database add column [real_length] numeric; Simon.