0
Answered

How to control order of views in generated SQL?

Grzegorz Kaczor 9 ár síðan updated by Michał Kołodziejski 9 ár síðan 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?

Answer

Answer
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.
Answer
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.