Your feedback is highly appreciated! Let's make Vertabelo even better.
No similar topics found.

+7
Under review
Option to hide all references and leave only tables displayed
My model is huge and it consists of over 100 tables and twice as more references. The jungle of lines was very confusing for me. Therefore, I deleted all references and used table colors, sizes and positions, as well as subject areas to visualize the structure of my database.
It would be great for me if Vertabelo had an option allowing user to hide all references without deleting them.
The other idea is to allow user to hide all references and show only these ones which are associated with the currently selected table. If no table is selected, all references are hidden but when the cursor is over the table, all references associated with that table are being displayed in gray. If user selects the table, all these references (associated with the table) are shown in normal color (black).
It would be great for me if Vertabelo had an option allowing user to hide all references without deleting them.
The other idea is to allow user to hide all references and show only these ones which are associated with the currently selected table. If no table is selected, all references are hidden but when the cursor is over the table, all references associated with that table are being displayed in gray. If user selects the table, all these references (associated with the table) are shown in normal color (black).

0
Answered
[PostgreSQL] Add quotes to generated SQL table names and columns
PostgreSQL does not require double quotes around table names and identifiers, it will just lower case them. However, I want them to remain in a certain case in the database. For example, if I add a table Team, I want it to show up as Team, not team. The generated sql will not add any quotes to the name unless it's a reserved keyword. Is there a way for me to add this? I only found this: http://support.vertabelo.com/topic/529465-postgresql-script-generated-ignore-double-quota-set-schema-and-tablespace-name/
but I don't think it's related.
Also with FK, if I have Team_id as a column, it will become team_id in the database w/o quotes. Help?
but I don't think it's related.
Also with FK, if I have Team_id as a column, it will become team_id in the database w/o quotes. Help?

Answer
anonymous
10 years ago
Just check the "Quote all SQL identifiers" checkbox in "SQL generation settings" section:

All table and column names will be in double quotes.

All table and column names will be in double quotes.

+2
Under review
Bulk update table properties
I would like to be able to bulk update properties of selected tables. For example, set tablespace for all tables except one. Or change initial value of multiple sequences. Now I have to click all the tables, one by one.

0
Answered
How to add and hide references on diagram?
I have table A which is connected to many other entities, and I want to organize my diagram better.
So I drag the second copy of table A (the one with dashed borders) to the diagram. And I drag table B next to it. How can I draw an existing reference between these tables?
And how can I hide reference between original table A and table B? I don't want to delete the reference, I just want to hide its particular instance in the picture.
So I drag the second copy of table A (the one with dashed borders) to the diagram. And I drag table B next to it. How can I draw an existing reference between these tables?
And how can I hide reference between original table A and table B? I don't want to delete the reference, I just want to hide its particular instance in the picture.

Answer
anonymous
10 years ago
So I drag the second copy of table A (the one with dashed borders) to the diagram. And I drag table B next to it. How can I draw an existing reference between these tables?OK, you can do this with exactly 4 mouse clicks. First, select those tables (2 clicks). Then click on the reference symbol in the menu and choose "Show all references" option:

The reference will show up.
And how can I hide reference between original table A and table B? I don't want to delete the reference, I just want to hide its particular instance in the picture.If an object (table or reference) has more than one visual representation (has dashed borders), it's deletion is deletion of visual representation only. The model object is deleted when its last visual representation is deleted.

0
Answered
How are anonymous models saved between browser sessions?
I'm curious as to how Vertabelo is remembering my (anonymous) model between my browser sessions. I have cookies turned off, so where is Vertabelo storing this information? I cleared my history, and the model is magically no longer saved (I figured it was done via cookies... so why is it gone now even though cookies were turned off earlier?). There are obvious reasons as to why this question is important.

0
Answered
How can you export the schema so as to import the schema into MS Access?
I want to be able to have all the tables and relationships imported so I can test queries.

Answer
anonymous
10 years ago
Vertabelo does not support MS Access in any special way.
If you want to test queries using a DBMS you chose when creating a model, I'd recommend you SQL Fiddle. It supports MySQL, Oracle, PostgreSQL, MS SQL Server and SQLite.
If you want to test queries using a DBMS you chose when creating a model, I'd recommend you SQL Fiddle. It supports MySQL, Oracle, PostgreSQL, MS SQL Server and SQLite.

0
Answered
Do high schools count under the educational plans?
I was just wondering if there was any way that my high school friend could register for vertabelo using his high school id and email as he is not in college yet. We are teaching each other how to build database systems.
Thanks
Thanks

0
Answered
Vilnius University Mathematical and Informatics faculty email address. Cannot get Academic plan. Possible to be fixed?
Tomas Juodokas 10 years ago
•
updated by Agnieszka Kozubek-Krycuń (Chief Scientist) 10 years ago •
1
Can you add this email to whitelist? Need vertabelo for learning and academic purposes.
University email: name.surname@mif.stud.vu.lt
Faculty website: http://mif.vu.lt/lt3/
University email: name.surname@mif.stud.vu.lt
Faculty website: http://mif.vu.lt/lt3/

0
Started
Check with newline generated to SQL without spaces
Grzegorz Kaczor 10 years ago
•
updated by Agnieszka Kozubek-Krycuń (Chief Scientist) 10 years ago •
3
I have a check:
CONDITION
OR
CONDITION
written in 3 lines. In generated SQL the check looks like:
CONDITIONORCONDITION
but it should be
CONDITION OR CONDITION
CONDITION
OR
CONDITION
written in 3 lines. In generated SQL the check looks like:
CONDITIONORCONDITION
but it should be
CONDITION OR CONDITION

0
Answered
How to control order of views in generated SQL?
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?
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?

Answer
anonymous
10 years ago
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.
Customer support service by UserEcho