October 2, 2021 - 1 minutes read

What Are Additional SQL Scripts and What Do You Use Them For in Vertabelo?

Dominika is a Python software developer. She graduated from the Warsaw University of Technology with a degree in computer science. At Vertabelo, she creates content as a technical writer. In her free time, she runs, practices yoga, and learns foreign languages.

Sometimes you need to perform actions that you can’t directly model in Vertabelo. For example, you might want to define functions or stored procedures, add users, or set permissions for objects such as tables or views. This can be done using additional SQL scripts. Here’s how.

Open your model. On the right, you can see the Model properties menu. Click Additional SQL scripts.

You can set scripts to run at the beginning or end of a create script or at the beginning or end of a drop script. Scroll down to see all the options available.

To add an additional script, simply paste it in the blank space provided.