0
Beantwortet

How to control order of views in generated SQL?

Grzegorz Kaczor vor 9 Jahren aktualisiert von anonymous vor 9 Jahren 1
How can I control the order in which views are written to generated SQL file?

I have 2 views - A and B that uses A. So I need A to be defined before I can define B. But Vertabelo defines B first, and the SQL fails.

Could you please help?

Antwort

Antwort
Beantwortet
In the "View properties" (on the right-hand side after selecting a view) there's a section called "Dependencies." Just add A as a dependency to the view B.
Antwort
Beantwortet
In the "View properties" (on the right-hand side after selecting a view) there's a section called "Dependencies." Just add A as a dependency to the view B.