Database Designer

Database Designer

Postby 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?
nlmunro
 
Posts: 1
Joined: Mon 27 Feb 2017 15:31

Re: Database Designer

Postby 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-with-database-designer.html
http://blog.devart.com/how-to-create-mysql-database-in-one-shot.html
http://blog.devart.com/quick-start-in-database-development-with-sakila-database-project.html

The 'dbForge Studio Tutorial Part No.1' demo video https://www.devart.com/dbforge/sql/studio/learn-more.html and the following articles for the similar our product would be also of help:
https://www.devart.com/dbforge/sql/studio/database-diagram.html
https://www.devart.com/dbforge/sql/studio/docs/index.html?designing_databases_with_database_designer.htm
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle