I already have a table created - Student list. It has columns namely, the student's name, age, class, rank....and also notes that the teacher has made regarding the student. now i want this notes to refer another table. is it possible? if so please 开发者_开发百科help me. Thanks in advance
Yes you can but not the way you are asking. You can not add a full table as a column to another but can use Foreign key concept (introduced in sqlite 3.6.19 [AFAIK]) in such situations.
精彩评论