0
Z odpowiedzią

How to control order of views in generated SQL?

Grzegorz Kaczor 9 lat temu Ostatnio zmodyfikowane przez anonymous 9 lat temu 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?

Odpowiedź

Odpowiedź
Z odpowiedzią
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.
Odpowiedź
Z odpowiedzią
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.