sql - Defining a view dynamically based on a table of table names -
Suppose I have a SQLite database, I'm adding regular views. Currently I have the following tables user, product, a, b, c to join me together a, b, and c one Using the scene. However, in the future, I would like to add more tables such as d and e , in this view, there is no way to define a scene so that it is dynamically Will these new tables be included? I think I will need to maintain a table of table names that I want to merge into this single scene, which is fine. This is not possible in pure SQL (SQLite has no ability to generate SQL dynamically from SQL And there are no triggers for table creation.) You have to create those sequences in those codes when you need them.