Page 1 of 1

Database Designer

Posted: Tue 25 Jul 2017 15:15
by nlmunro
I just wanted to ask if I'm missing something... are there really no "helpers" to automate creation of tables, for example:

1. Creating auto-increment primary keys (create Sequence, create Trigger)
2. Adding Foreign keys (drag ID to external table and it creates FK)

Do I really have to do this sort of donkey work manually?

Re: Database Designer

Posted: Wed 26 Jul 2017 09:41
by alexa
1. Creating auto-increment primary keys (create Sequence, create Trigger)
We will review this when developing the next product versions.
2. Adding Foreign keys (drag ID to external table and it creates FK)
This can be done on the Database Diagram that can be opened by selecting 'File -> New -> Database Diagram' from the main menu.

Please see the following:
http://blog.devart.com/getting-started- ... igner.html
http://blog.devart.com/how-to-create-my ... -shot.html
http://blog.devart.com/quick-start-in-d ... oject.html

The 'dbForge Studio Tutorial Part No.1' demo video https://www.devart.com/dbforge/sql/stud ... -more.html and the following articles for the similar our product would be also of help:
https://www.devart.com/dbforge/sql/stud ... agram.html
https://www.devart.com/dbforge/sql/stud ... signer.htm