I have a table schema that looks like this: 




_ID integer primary key autoincrement 
name varchar(40) 
category varchar(40) 
recommendation varchar(40) 



I would like to restrict the values that are entered into the "recommendation" 
column. 

How would I state that at the time I create the column in that table? 

Since that table/column exists today without any restrictions, how do I alter 
it to restrict the values entered? 



Thank you in advance to anyone wishing to reply. 



-Chris 


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to