On 6/17/2017 1:59 AM, Robert M. Münch wrote:
Hi, suppose I store my data like this:
Table A: table, column, data
Now I want to create a VIEW named A.table, with columns A.column and rows A.data
Is that possible?
I don't think so. The number and names of columns in the view are determined at
the time CREATE VIEW statement is executed. I don't believe you can have a view
whose schema magically changes as the data in the underlying table changes.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
