samedi 11 avril 2015

Modify Sqlite Table Column NOT NULL to NULL

I am looking for something similar to this but I'm using sqlite3. I have tried:



sqlite> UPDATE JOBS SET JOB_TYPES = NULL;


But I got "constraint failed". Am I doing it the correct way?


I want to change the current "NOT NULL" to "NULL".


Thanks.


Aucun commentaire:

Enregistrer un commentaire