jeudi 11 juin 2015

sqlite schema has quotes around table name after a table rename

I had to rename an existing table in my sqlite database using the following command:

ALTER TABLE users RENAME TO widgets;

After running that command, when I check the schemas using the .schema command, this is what I see:

CREATE TABLE "widgets"(id integer primary key AUTOINCREMENT, widget_tag varchar(10), destination varchar(100), class varchar(10), name varchar(255), grp active bit(1));
CREATE TABLE uu(id integer primary key AUTOINCREMENT, uu_name varchar(255), email varchar(255), active bit(1));

Notice the quotes around the table name. I'm not sure if that's a bad thing or not. My web application runs just fine and I'm able to update / delete / select records no problem.

Can someone tell me what these quotes are and if I need to worry ? Thanks.

Aucun commentaire:

Enregistrer un commentaire