At 08:51 21/05/2015, you wrote:
>I used sqlite3.exe by invoking it on the command line with the name of
>a database.
>Next I typed
>
> alter table database add column real_length numeric;
>
>Next I typed .fullschema
>and I'm getting:
>
>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 */
>
>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;
^ missing )
Probably because you used a third-party tool (like SQLite Expert) to
create the table. Such tools often --and I know Expert does-- enclose
schema names in a given pair of delimiters [...], "..." or `...` while
the CLI simply issues the SQL command like you input it.
