SQLite Forum

Dot Command - Square Brackets
Login
My understanding that SQL names that
<ol><li> are SQL keywords OR </li><li>contain special character such as space or hypen</li></ol> need to be wrapped in square brackets. <i>Double quotes are sometimes used instead of square brackets.</i>

The following work:
<ol><li>.schema 1980-1982_F </li><li>.schema "1980-1982_F"</li></ol> but 
<ul><li>.schema [1980-1982_F] </li></ul> returns nothing i.e. fails.

Likewise for .dump

Is this inconsistency an -ism?

This statement
 
.schema 1980-1982_F

ought to return an error since <i>1980-1982_F</i> contains special characters.