1. Vertabelo
  2. Питання
0
Є відповідь

Oracle. Triggers/synonyms/comments while creating tables

Anna Kovaleva 8 років тому • оновлено Rafał Strzaliński (Senior Engineer) 8 років тому • 1

My model have been created under the Oracle 11g. So, could you please describe how I can add triggers, synonyms for a tables? Also i'm interested in how a comments could be added for a tables and columns.

Would like to say thank you for that great project! It will be great to have such an instrument. I like it simple approach to work with a team of developers.

Thank you in advance.

Є відповідь
Rafał Strzaliński (Senior Engineer) 8 років тому

Hi,


Here you have an instruction about adding comments:

http://www.vertabelo.com/blog/documentation/database-modeling-tip-7-how-to-include-comments-in-sql-script


You may add triggers and synonyms as plain SQL commands:

1. Click on table on the diagram.

2. Click on "Additional SQL Scripts" panel on the right side.

3. Add definition of triggers and synonyms in "After create table" field.


Hope it helps. Enjoy Vertabelo.





Служба підтримки клієнтів працює на UserEcho