How to add and edit a table?
You can add a table in two ways:
1. by clicking the
Table icon in the top toolbar and indicating the position of the table in the diagram.
2. by clicking in the explorer after opening the
Tables object list. In this case, the position of the table will be selected automatically.
To edit the table, right-click its title and select
from the popup menu. Additionally, you can edit the table in the properties panel (on the right) by changing the properties of the table or its columns.
How to change the order of columns?
The order of columns can be changed by clicking the up/down arrows in the property panel after selecting the column first. This can also be done in the table editing window.
How to add / edit a note?
Adding a note is done similarly to the table, i.e. by clicking the icon in the toolbar and indicating the position or by clicking in the explorer after opening the Objects -> Notes menu. After adding a note, if the property panel is enabled, the cursor will be positioned in the edit field where you can enter the text of the note.
How to maximize the editing area?
The program has two side panels, the object explorer (left) and the object property panel (right). Both can be hidden by clicking the appropriate icons.
Zoom in and out of the diagram
The program allows you to view any part of the diagram in any scale. The following functions are available in the toolbar:
1. scale 1:1 (original)
2. zoom in and out
3. adjust the scale to the entire diagram
Additionally, the zoom can be adjusted using the mouse scroll.
How to add a relationship between tables?
To create a relationship, click the
Relation icon in the top toolbar. Then point at the parent table and drag the cursor to the sub-table.
A dialog box will open in which
Relation fields from both tables should be merged and the change saved.
How to add a recurring relationship?
Adding a recursive relationship is similar to adding an ordinary one. The only difference is that the same table should be indicated as the parent and subordinate.
How to add UNIQUE index?
Right-click the table title and select
Create Index from the popup menu.... In the dialog box, enter a name for the index, indicate the UNIQUE type and add fields.
The difference between the diagram and the subject area
In general, a diagram is a visual presentation of selected tables and relations between them. The subject area is a group of diagrams.
How to change diagram settings?
The diagram settings can be changed in the properties panel. You can also point to the diagram (in the list on the left) with the right mouse button and from the popup menu click
Edit... to open the diagram dialog.
Adding, removing and searching for an object
Database project explorer allows you to check which objects the project contains. It allows you to add, delete and search for objects. One of the useful tools is
target. It allows you to quickly find the object in the open diagram. It is useful mainly in complex database projects.
How to generate a SQL script from a diagram?
To create a SQL script, click the
Generate Script icon on the left toolbar. It will open a page with a list of objects on the left and a screen showing the script in the central part. Select the tables to be exported and confirm by clicking
Generate SQL. After creating the script you can download it to disk or copy it to the clipboard.
How to create a diagram from a script?
To do so, click on the
Import Script icon on the left toolbar and the
Load button at the top. In the
Script Import dialog box, click
Load File, select a file from the disk and confirm by clicking
Import. If the import is successful, a diagram with the imported objects will open.
Generating upgrade scripts.
The generation of upgrade scripts is done in the same way as the generation of SQL scripts for the new database with the difference that at least two versions of the project (usually the last two) should be indicated here.
How to share the project with other users?
Sharing a project in SqlDBD consists in granting access (for editing or review) to selected people to an open project. Granting access will work if the following conditions are met:
1. the user receiving the invitation has an account in SqlDBD and the inviting user will provide his e-mail address which is the login to the account.
2. both the user providing and receiving the invitation have activated accounts (the activation link comes to the e-mail address provided immediately after registration).
How to check which users have access to the project?
To do this, click the main menu icon (upper left corner) and select
Share.... The list of users with whom the project is shared will be displayed in the open dialog box on the
What projects are available to me?
Projects shared by other users are visible on the list of shared projects (under the list of own projects).
The program has two themes - dark and light. You can change the theme directly from the main menu or from the settings window.
How do I change my password?
The forgotten password cannot be recovered. You can set a new password in the form on page . To do so, enter the e-mail address that is your account login and click
Send link to change your password. A message with a link to the form will come to the indicated e-mail address, in which you can set a new password.
How to change user login?
In order to change your login you should send:
1. a request from the
Support request form after logging in to your account,
2. a message from the e-mail address which is the new login. In both cases you should specify from which and to which e-mail you want to change your login.
The free plan is primarily designed to familiarize yourself with the possibilities of the program before buying the subscription. It allows you to work on one project up to twenty tables. The free plan limits the generation of scripts to two tables and the review of database versions to the last three.
Paid plans - settlement rules.
Permits one user to design an unlimited number of database objects. Within the plan it is possible to share projects with other users only if they have a paid subscription.
It has all the features of the PROGRAMMISTA plan and the possibility to share the project with a selected number of users, including those without a paid subscription.
7-day test period.
For the first 7 days after registration, you can take advantage of all the features of the program, including teamwork. After this period you can use the free plan or buy one of the two paid plans.