Wählen Sie Ihren SQL-Server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Neuheiten abonnieren
Partners
Testimonials
Andrey Bistriy: "In our daily business we face the database management and refactoring. We were pleasantly surprised to discover SQL Maestro. After trying it out we started to use it on a regular basis".
Carl Schammel: "I have been in search of a software product that was rich in features and easy for using, but was unable to find one until I came upon Firebird Maestro. Not only does it have all-inclusive integrated functionality, but SQL Maestro Group have provided me with superior support. I now have the management tools at my hand that I have been looking for".

More

Add your opinion

Firebird Maestro online Help

Prev Return to chapter overview Next

Database Object Management

Firebird 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 Firebird Maestro.

 

UDFs

 

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;

or

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.

 

 

 

Firebird 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

or

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).

 



Prev Return to chapter overview Next