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

Subscribe to our news:
Partners
Testimonials
Steve Horne: "All in all it's a great product, I used the freeware version for a while but purchased a commercial license recently as I am now using it for my work. The ability to query SharePoint lists using SQL makes my administration tasks much easier".
Steve Naidamast: "I just downloaded your new offering of AnySQL Maestro. What a nice product. I was immediately able to connect to an Access database to review the data.

I have already purchased from you your Oracle Maestro as well as your SQLite Maestro.

I am curious as to why you have decided to release such a nice product as Freeware...

Keep up the excellent work".

More

Add your opinion

AnySQL Maestro online help

Prev Return to chapter overview Next

Database Object Management

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

 

 

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.

 

 

 

AnySQL 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