Online Documentation for SQL Manager for InterBase/Firebird
Welcome to SQL Manager for IB/FB! |
What's new |
System requirements |
Feature Matrix |
Installation |
Registration |
How to register SQL Manager |
EMS SQL Manager FAQ |
Other EMS Products |
Getting Started |
Selecting style and language |
First time started |
Using Desktop Panel |
Database navigation |
Working with database objects |
Using context menus |
Host context menu |
Database context menu |
Object context menu |
Working with windows |
Database Explorer |
Managing database registration info |
Connecting to databases and hosts |
Operations with database objects |
Selecting multiple objects |
Using tabs for database navigation |
Recently opened objects |
Managing favorite objects |
Searching within the tree |
SQL Assistant |
Configuring Database Explorer |
Managing Favorite queries |
Database Management |
Register Host wizard |
Setting connection parameters |
SSH tunneling parameters |
SSL parameters |
Setting specific options |
Create Database wizard |
Selecting host |
Setting connection parameters |
Specifying database parameters |
Defining database files |
Viewing result SQL statement |
Register Database wizard |
Selecting host |
Database on a registered host |
Setting connection parameters |
Database on a new host |
Setting connection parameters |
Setting specific options |
Database Registration Info |
Connection |
Options |
Display options |
System objects |
Grid |
Data options |
Transactions |
Events |
Directories |
Logs |
Find Option |
Database Properties |
Info |
General |
Active users |
Description |
Secondary Files |
Find Option |
Host Registration Info |
Connection |
Common host options |
SSH tunneling |
SSL parameters |
Find Option |
Database Objects |
New Object |
Duplicate Object Wizard |
Selecting the source database |
Selecting object to duplicate |
Selecting destination database |
Specifying object details |
Viewing the new object's definition |
Domains |
Using Navigation bar and Toolbar |
Creating/editing domain |
Defining domain check |
Tables |
New Table |
Using Navigation bar and Toolbar |
Setting table properties |
Specifying fields |
Table Editor |
Using Navigation bar and Toolbar |
Managing fields |
Changing fields order |
Managing constraints |
Primary keys |
Foreign keys |
Checks |
Unique constraints |
Managing indices |
Managing triggers |
Working with table data |
Fields |
Field Editor |
Setting field name and type |
Options for domain-based field |
Options for field of standard data type |
Defining array |
Specifying 'COMPUTED BY' expression |
Setting field defaults |
Defining autoincrement |
Defining generator |
Defining trigger |
Defining procedure |
Setting field check |
Table Constraints |
Constraints Editor |
Creating/editing primary key |
Creating/editing foreign key |
Creating/editing check |
Creating/editing unique key |
Indices |
Index Editor |
Specifying index properties |
Selecting index fields |
Triggers |
Trigger Editor |
Creating table-based objects |
View from Table |
Options |
View info |
View triggers |
Procedures from Table |
Options |
SELECT procedure |
INSERT procedure |
UPDATE procedure |
DELETE procedure |
Views |
Using Navigation bar and Toolbar |
Creating/editing view |
Managing fields |
Managing triggers |
View plan |
Working with data |
Procedures |
Procedure Editor |
Using Navigation bar and Toolbar |
Creating/editing procedure |
Executing procedure |
Working with data |
Procedure/Trigger Debugger |
Using Navigation bar and Toolbar |
Debugging procedure/trigger |
Browsing debug information |
External Functions |
Using Navigation bar and Toolbar |
Creating/editing external functions |
SQL Functions |
Using Navigation bar and Toolbar |
Creating/editing SQL Functions |
Triggers |
Using Navigation bar and Toolbar |
Creating/editing trigger |
Managing trigger messages |
Exceptions |
Using Navigation bar and Toolbar |
Creating/editing exception |
Generators |
Using Navigation bar and Toolbar |
Creating/editing generator |
BLOB Filters |
Using Navigation bar and Toolbar |
Creating/editing BLOB Filter |
Journals |
Journal Editor |
Using Navigation bar and Toolbar |
Creating/viewing journal |
Journal management |
Database Triggers |
Using Navigation bar and Toolbar |
Creating/editing DB Trigger |
Collations |
Using Navigation bar and Toolbar |
Creating/editing collation |
Packages |
Using Navigation bar and Toolbar |
Creating/editing package |
Query Tools |
Query Data |
Using Navigation bar and Toolbar |
Working with queries |
Using the context menu |
Viewing query plan |
Using object links |
Executing queries |
Viewing query logs |
Favorites editor |
Design Query |
Using Navigation bar and Toolbar |
Working with diagram area |
Joining two objects |
Setting criteria |
Setting output fields |
Setting grouping criteria |
Setting sorting parameters |
Working with the editor area |
Query execution |
Viewing query plan |
Query parameters |
Input parameters dialog |
Data Management |
Data View |
Using Navigation bar and Toolbars |
Grid View |
Customizing columns |
Grouping and sorting data |
Filtering records |
Using the context menu |
Working in multi-level mode |
Create Grid Level wizard |
Specifying master level |
Defining source for detail level |
Binding master and detail levels |
Query parameterization |
Setting additional parameters |
Working in card view mode |
Column Summary |
Copying records |
Form View |
Print Data |
Page Setup |
Page |
Margins |
Header/Footer |
Scaling |
Report Formatter |
View |
Behaviors |
Formatting |
Styles |
Preview |
Cards |
Charts |
Setting report options |
Print dialog |
BLOB View |
Navigation within BLOB Editor |
Editing as Hexadecimal |
Editing as Text |
Editing as Rich Text |
Editing as Image |
Editing as HTML |
Applying changes |
Custom Filter |
Filter Builder dialog |
Invoking the Filter Builder dialog |
Adding a new condition |
Setting filter criteria |
Setting filter operator |
Setting filter criteria values |
Adding a new group |
Setting group operator |
Applying filter conditions |
Import/Export Tools |
Export Data Wizard |
Setting destination file name and format |
Selecting fields for export |
Adjusting data formats |
Setting header and footer |
Setting format-specific options |
Excel 97-2003 options |
Data format |
Fields |
Options |
Styles |
Extensions |
Hyperlinks |
Notes |
Charts |
Cells |
Merged Cells |
Advanced |
Access 97-2003 options |
Word 97-2003 / RTF options |
Base Styles |
Strip Styles |
HTML options |
Preview |
Basic |
Multi-file |
Advanced |
PDF options |
TXT options |
CSV options |
XML options |
MS Excel / ODS options |
Access options |
MS Word / ODT options |
Setting common export options |
Exporting data |
Import Data Wizard |
Selecting source file name and format |
Selecting data source |
Setting fields correspondence |
Excel 97-2003 |
Access/DBF/XML Datapacket |
TXT |
CSV |
HTML |
XML Generic |
MS Excel/Word, ODF |
Adjusting data formats |
Setting advanced field formats |
Setting import mode |
Customizing common options |
Importing data |
Export as SQL Script |
Selecting destination DBMS |
Setting destination file name |
Setting BLOB options |
Selecting fields to export |
Editing table definition |
Setting export options |
Exporting as SQL Script |
Database Tools |
Dependency Tree |
Using Navigation bar and Toolbar |
Viewing dependency tree |
SQL Monitor |
Using Navigation bar and Toolbar |
Working with SQL Monitor |
Execute Script |
Using Navigation bar and Toolbar |
Working with SQL Script editor area |
Using Script Explorer |
Script execution |
Extract Database Wizard |
Selecting source database |
Specifying destination file name |
Setting extraction mode |
Setting BLOB options |
Selecting objects for structure extraction |
Selecting objects for data extraction |
Customizing script options |
Start of extraction process |
Print Metadata |
Using Navigation bar and Toolbar |
Selecting objects |
Printing options |
HTML Report Wizard |
Selecting database and directory |
Selecting object types |
Specifying CSS |
Setting additional report options |
Creating HTML report |
Reports management |
Create Report Wizard |
Specifying database name and report options |
Selecting report bands |
Selecting report style |
Specifying page settings |
Specifying paper settings |
Specifying margins |
Specifying other page settings |
Report Designer |
Adding dialog form |
Adding database and query components |
Adding report data |
Saving the report |
Report Editor |
Using Navigation bar and Toolbar |
Viewing Report |
Report Viewer |
Using Toolbar and context menu |
Working with Report Viewer |
Page settings |
Exporting report content |
Sending by E-mail |
Search in Metadata |
Using Navigation bar and Toolbar |
Setting search conditions |
Viewing search results |
Database Monitor |
Using Navigation bar and Toolbar |
Database overview |
Viewing transactions |
Viewing statements |
Viewing users |
Viewing call stack |
Viewing procedures |
Viewing relations |
Viewing triggers |
Memory usage |
Event Monitor |
Using Navigation bar and toolbar |
Working with Event Monitor |
Table Altering Monitor |
Using Navigation bar and Toolbar |
Working with Table Altering Monitor |
Server Messages Editor |
Using Navigation bar and Toolbar |
Working with server messages |
Go to Message Number dialog |
Editing Server Messages |
Database Designer |
Using Navigation bar and Toolbars |
Using Diagram Navigator and DB Objects pane |
Using context menus |
Working with diagram objects |
Adding/removing objects to/from diagram |
Creating objects |
Creating relations |
Working with diagram pages |
Reverse engineering |
Printing diagram |
Print Preview |
Print Setup dialog |
Saving/loading diagram |
Setting diagram options |
Services |
Backup Database |
Selecting database and backup type |
Backup type-specific options |
Full Backup options |
Archive Backup options |
Incremental Backup options |
Setting backup options |
Running backup |
Restore Database |
Selecting restore type |
Restore type-specific options |
Restore from Full Backup |
Restore from Incremental Backup |
Restore from Journal Archive |
Restore Online Dump |
Setting restore options |
Running restore |
Database Validation |
Selecting database and execution mode |
Setting validation options |
Running database validation |
Database Statistics |
Selecting database and execution mode |
Setting statistics options |
Running statistics collection |
Start/Stop Database |
Selecting database and execution mode |
Setting shutdown options |
Running Bring Online / Shutdown Database |
Rebuild Database Indices |
Selecting database and execution mode |
Selecting action for indexes |
Selecting indexes |
Recomputing/rebuilding indexes |
Purge Database |
Selecting database and execution mode |
Selecting options for data deleting |
Selecting tables to purge data |
Running purging operation |
Security management |
User Manager |
Using Navigation bar and Toolbar |
Managing users |
User Editor |
Embedded User Editor |
Role Manager |
Using Navigation bar and Toolbar |
Managing roles |
Defining role members |
Grant Manager |
Using Navigation bar, Toolbar and context menu |
Managing database-specific privileges |
Managing DDL grants |
Managing column permissions |
Filtering objects in list |
Options |
Environment Options |
Preferences |
Full mode activation |
Confirmations |
Appearance |
DB Explorer |
Search |
SQL Assistant |
Tools |
Query Data |
SQL Monitor |
Execute Script |
Design Query |
Style & Color |
Database Designer |
Extract Database |
Print Metadata |
Database Monitor |
Dependencies |
Data Export |
Object Editors |
Table Editor |
Visual Mode Editors |
Fonts |
Grid |
Data Options |
Print Data |
Color & Formats |
Advanced |
Column Options |
Localization |
Global Shortcuts |
Find Option |
Editor Options |
General |
Display |
Color Scheme |
Code Completion |
SQL Formatter |
SQL Words |
Key Mapping |
Spell Checking |
Find Option |
Save Settings |
Specifying destination file |
Selecting settings |
Selecting databases |
Saving settings |
Localization |
Localization Editor |
Select Program Language |
Keyboard Templates |
Object Templates |
Find Option dialog |
External Tools |
External Tools dialog |
External Tool Info editor |
How To... |
Work with Databases |
Connect to a database |
Create a database |
Edit database connection parameters |
Make work with a database faster |
Design a visual database structure |
View an ER diagram |
Backup a database |
Restore a database from a backup |
Create a database copy |
Document a database |
Save metadata reports to file |
Log database changes |
Get an SQL dump |
Work with Database Objects |
Group objects |
Find objects |
View dependecies |
Get an object DDL |
Work with Data |
View tables with many records |
Set data filter |
Sort and group data |
Export/import data |
Export data as SQL Script |
Export filtered data |
Create an autoincrement field |
Edit data of master-detail tables |
Add image to table |
Set data display format |
Work with Queries and Scripts |
Create SQL statements rapidly |
Work with several queries at once |
Save most frequently used queries |
Execute queries with parameters |
Export query results into file |
Execute scripts |
Execute a large SQL script |
Make SQL script work faster |
Customize work with Query/Script text |
View executed queries and scripts |
Create a simple report in Report Designer |
Transfer program settings |
Update SQL Manager |
Report bugs and suggestions |
Appendix |
Program interface |
Viewing object DDL structure |
Editing object description |
Browsing object dependencies |
Setting object permissions |
Managing parameter properties |
Specifying input parameters |
Viewing object operations |
Viewing performance analysis |
Compile window |
Find Text dialog |
Replace Text dialog |
Format specifiers |
Language Info Editor |
Using templates |
Supported file formats |
To-Do List |
Windows List |
Customize toolbars and menus |
SSH tunneling options |
Quick save / Quick load |
Connection Lost dialog |
SQL Manager Direct |
Login Host / Login Database dialogs |
Overwriting existing output file |
Script conversion |
Select Object dialog |
SQL Manager shortcuts |
© 1999-2024 EMS Software Development