开发者

Can we add a table to as a column of another table in SQLite Database?

开发者 https://www.devze.com 2023-03-16 22:08 出处:网络
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

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消