[sqlite] Re: problem with creating a table

[Igor Tandetnik]

Bijan Farhoudi <farhoudi-RazJlWb3c/[EMAIL PROTECTED]> wrote:
A. Pagaltzis wrote:
    SELECT [order] FROM foo
But how would you know the name of the col is "order"  not "[order]"?

Square brackets are not part of the name. They are delimiters that 
indicate that whatever's inside is to be treated as an identifier (just 
as in string literal 'x', quotes are not part of the string but are 
delimiters indicating that it is indeed a string literal). This syntax 
allows identifiers that would otherwise be reserved words, as well as 
identifiers that otherwise would not be valid (e.g. having spaces or 
punctuation in them, e.g. [this is a valid column name] ).

Igor Tandetnik