SQLite Forum

pragma table_info Bug
Login
Use double quotes or backticks instead. (But then field size won't be shown in table_info).
```
sqlite> create table h(i "unsigned word"(3));
sqlite> pragma table_info(h);
cid|name|type|notnull|dflt_value|pk
0|i|unsigned word|0||0
```