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

Subscribe to our news:
Partners
Testimonials
Renaud Lepage: "I was searching for a powerful server management as well as data management application, that could also have the ability to use stored procedures (MySQL5). I was using many separate apps. And then I stumbled upon this application. It just got better. With ease-of-use, powerful management, a very good level of customization, great MySQL server management and the very lushed graphical interface, MySQL Maestro is a product to consider seriously. I chose MySQL and this, to SQL Server 2000 and the MMC-integrated server management, for use in a programming course. I'm telling you, MySQL Maestro is a very powerful tool. Try it, you won't regret it".
Adam Allen: "I just have to say WOW!!! I'm so glad that you guys have developed something that is so useful for MySql. I am able to graphically view my tables, and I don't even have to think about my queries because I can visually design them. I just stumbled upon this, and I'm already very excited about it".

More

Add your opinion

Customers
Download Buy

SQL Maestro for MySQL online help

Prev Return to chapter overview Next

SQL Definition

The SQL tab displays the SQL definition for the object with all its properties. Bear in mind that this text is read-only. If you want to change the object definition, use the appropriate editor tabs instead, or copy the text to the Windows Clipboard to paste it in SQL Editor or SQL Script Editor.

 

The SQL definition window allows you to browse the text effectively. The popup menu and the extensive system of hot keys give you the opportunity to search expressions within the text, to select the whole text for copying it to the Windows Clipboard, to save the definition to the *.sql or *.txt files, to print the document, etc.

 

You can customize the displayed definition using the Editors & Viewers options.

 

The Properties item of the popup menu displays the Options dialog in which you can establish optional settings concerning the current database.

The Code Folding item group makes it possible to view either the whole text or its logical parts (regions). Each region can be collapsed and extended.

 

In extended mode the whole text is displayed (set by default)  

 

In collapsed mode the text is hidden behind one text line denoting the first line of the collapsed region.

 

Navigation Bar on the SQL tab allows you to copy the object’s SQL definition (DDL) to the SQL Script Editor for future modifications.



Prev Return to chapter overview Next