0
Answered

How to control order of views in generated SQL?

Grzegorz Kaczor 9 aastat tagasi uuendaja anonymous 9 aastat tagasi 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?

Vasta

Vasta
Answered
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.
Vasta
Answered
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.