1. Vertabelo
  2. Spurningar
0
Answered

Oracle. Triggers/synonyms/comments while creating tables

Anna Kovaleva 8 ár síðan • updated by Rafał Strzaliński (Senior Engineer) 8 ár síðan • 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.

Answered
Rafał Strzaliński (Senior Engineer) 8 ár síðan

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.





Customer support service by UserEcho