John Newby wrote:
> Does anyone know any reason why SQLite doesnt like tables called "Table" or
> is this a standard SQL thing?
>
> Many thanks
>
> John
>
I guess that 'Table' is a reserved keyword, part of the SQL language.
If you _really_ want to have a table, named 'table', you should put the name
between quotes in the SQL query :
sqlite> create table table (value TEXT);
SQL error: near "table": syntax error
sqlite> create table 'table' (value TEXT);
sqlite> .schema
CREATE TABLE 'table' (value TEXT);
sqlite> select * from 'table';
sqlite> select * from table;
SQL error: near "table": syntax error
sqlite>
Cheers,
Jonathan
