SQLite Maestro online Help

Return to chapter overview

Database Object Management

SQLite Maestro provides you with powerful tools to manage database objects.

Note: before working with database objects you should connect to the database first (see Database Management).

The following list contains the most common database objects supported by SQLite Maestro.

•

Tables

•

Views

Below you can find some common ways of database object management.

To create a database object:

•	select the Object \| Create Database Object main menu item;

•	select the type of the object to be created in the Create Database Object dialog;

•	select the appropriate node in the explorer tree;

•	select the Create New Object... item from the popup menu;

and follow the steps of the wizard or edit object properties in the dialog (depending on the selected object type).

To edit any database object:

•	select the database object in the explorer tree;

•	select the Edit Object item from the popup menu of the database object to edit.

To drop any database object:

•	select the database object in the explorer tree;

•	press the Delete key or select the Drop Object item from the popup menu of the database object to drop;

•	confirm dropping in the dialog window.

SQLite Maestro offers several ways of objects duplicating.

1.	Duplicate Object Wizard. The wizard is the most flexible tool of the coping. Along with a possibility to adjust the new object definition it allows you to copy data (for tables). But it consists of several steps and takes more time than other manners.

2.	Duplicate Object window allows you to attune new object's SQL definition. It is preferred for creation a copy of selected object. Here you can find some additional info.

3.	By Drag-n-Drop operation.

There is a simple way to supply a comment for any database object using the Comment for the Object dialog. In order to open the dialog you should either

•	select the appropriate object in the explorer tree;

•	select the Describe Object... item from the popup menu

•	open the object container editor and go on to the appropriate tab;

•	select the object to supply comment for;

•	select the Describe Object item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).