Am 21.05.2015 um 13:44 schrieb Simon Slavin:
> 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.
>
That's interesting. Thanks for claryfying.
--
Christoph