Database Designer

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
nlmunro
Posts: 1
Joined: Mon 27 Feb 2017 15:31

Database Designer

Post by nlmunro » Tue 25 Jul 2017 15:15

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?

alexa
Devart Team
Posts: 2429
Joined: Fri 24 Jun 2011 14:17

Re: Database Designer

Post by alexa » Wed 26 Jul 2017 09:41

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

Post Reply