Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".
Ephraim Stevens : "I just wanted to re-iterate what a wonderful job your developers have done and what a wonderful product SQLite Maestro is. There are so many great things to say about it that I won't go into here. It saves an end user a lot of time on repetitive tasks. Keep up the excellent work over there".

More

Add your opinion

Customers
Download Buy

SQLite Maestro online Help

Prev Return to chapter overview Next

Schema Designer

Schema Designer allows you to create physical Entity Relationship Diagram that will represent objects in your SQLite  database. A diagram represents the tables of your database. The tool is intended for reverse engineering and database modification in an easy and powerful way. It helps you to simplify database maintenance.

 

A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations. The data diagram can also serve as an invaluable communications tool for both internal and external constituents.

 

 

Below you can find answers for the following questions:

 

See also: Designer Navigation bar, Schema Designer Toolbox.

 

Adding a table

You can add an existing SQLite  table to the diagram using popup menu in the working area, or with the corresponding link on the Navigation bar.

 

To create a new table, use the appropriate item of the popup menu in the working area. The table will be created in the current database.

 

Tables also may be dragged on the diagram from Explorer and the similar to Explorer tools like Object Manager and Object Browser.

 

All the diagram objects are available for editing. Just double click the object (table or relationship) to view/edit its properties within the corresponding editor.

 

Deleting of the diagram objects

To hide a table (several tables), select the objects and click Remove selection link of the popup menu or Navigation bar. You can also use the Del key for this purpose.

 

It’s also possible to physically delete a table from the database: just select the object to delete and use the appropriate item of the popup menu.

 

Editing of a diagram appearance

Movement of a table/several tables along the diagram is realized with dragging or pressing Ctrl+arrows. You can use Shift+arrows to change width/height of table/several tables representation.

 

Designer also allows you to edit shape of the line representing logical relations. In order to break the line you should

•Select the relationship.
•Press Ctrl and click on the necessary line section to create a new node.
•Position the node by dragging.

 

You can also delete a node on the line. Thereto

 

•Select the relationship.
•Press Alt and click the node to delete. In that case the near nodes will be united by a straight line.


Prev Return to chapter overview Next