0
Є відповідь

How to control order of views in generated SQL?

Grzegorz Kaczor 9 років тому оновлено anonymous 9 років тому 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?

Відповідь

Відповідь
Є відповідь
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.
Відповідь
Є відповідь
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.