EMS logo

EMS SQL Manager for InterBase/Firebird

Documentation en ligne



Welcome to SQL Manager 2005 for InterBase/Firebird!
What's new
System Requirements
Feature Matrix
Installation
Registration
License Agreement
Version History
Other EMS Products
Getting Started
Selecting style and language
Fisrt time started
Using Desktop Panel
Working with databases
Working with database objects
Using database popup menu
Using object popup menu
Switching between windows
Database Explorer
Managing database registration info
Connecting to database
Performing database object operations
Creating projects
Viewing dependent objects
Navigating database objects with tabs
Selecting multiple objects
Recently opened objects
SQL Assistant
Configuring Database Explorer
Database Management
Create Database Wizard
Selecting database host
Setting database general options
Defining database files
Viewing result SQL statement
Register Database Wizard
Setting connection properties
Registering DB on a new host
Setting registration options
Register Host Wizard
Setting connection parameters
Setting registration options
Database Registration Info
Connection properties
Database options
System objects options
Data options
Default directories
Log options
Host Registration Info
Connection properties
Host options
SSH tunneling
Database Properties
Setting database properties
Database Object Management
New Object
Duplicate Object
Duplicate Object Wizard
Selecting source database
Selecting object to duplicate
Selecting destination database
Modifying new object's definition
Changing Metadata window
Saving / Loading
Domains
Domain Editor
Using navigation bar
Editing domain definition
Editing domain check
Browsing object dependecies
Editing domain description
Viewing DDL definition
Tables
New Table
Using navigation bar
Setting table properties
Specifying fields
Table Editor
Using navigation bar
Managing fields
Changing fields order
Editing table constraints
Using navigation bar
Managing primary keys
Primary Key Editor
Editing primary key definition
Viewing DDL definition
Managing foreign keys
Foreign Key Editor
Editing foreign key definition
Viewing DDL definition
Managing checks
Check Editor
Editing check definition
Viewing DDL definition
Managing unique keys
Uniques Editor
Editing unique key definition
Editing unique description
Viewing DDL definition
Managing indexes
Managing triggers
Browsing object dependecies
Viewing table data
Editing table description
Viewing DDL definition
Fields
Field Editor
Setting field name and type
Setting field defaults
Defining array
Defining autoincrement
Setting field checks
Setting field description
Viewing DDL definition
Indexes
Index Editor
Editing index definition
Editing index description
Viewing DDL definition
Creating table view
Views
View Editor
Using navigation bar
Editing view definition
Viewing fields
Managing triggers
Editing view description
Viewing data
Browsing object dependecies
Viewing query plan
Viewing perfomance analysis
Viewing DDL definition
Triggers
Trigger Editor
Using navigation bar
Editing trigger definition
Editing trigger message
Browsing object dependecies
Editing trigger description
Viewing DDL definition
Procedures
Procedure Editor
Using navigation bar
Editing procedure definition
Editing procedure description
Browsing object dependecies
Browsing procedure operations
Executing procedure
Viewing perfomance analysis
Viewing DDL definition
Stored Procedure Debugger
UDFs
UDF Editor
Using navigation bar
Editing UDF definition
Browsing object dependecies
Editing UDF description
Viewing DDL definition
Exceptions
Exception Editor
Using navigation bar
Editing exception definition
Browsing object dependecies
Editing exception description
Viewing DDL definition
Generators
Generator Editor
Using navigation bar
Editing generator definition
Browsing object dependecies
Viewing DDL definition
BLOB Filters
BLOB Filter Editor
Using navigation bar
Editing BLOB Filter definition
Browsing object dependecies
Editing BLOB Filter description
Viewing DDL definition
Queries
SQL Editor
Using navigation bar
Viewing query plan
Viewing performance analysis
Working with editor area
Using object links
Using popup menu
Executing query
Visual Query Builder
Using navigation bar
Working with diagram area
Joining two objects
Setting criteria
Setting output fields
Setting grouping criteria
Setting parameters of sorting
Working with editor area
Executing query
Viewing performance analysis
Query parameters
Input parameters dialog
Data Management
Data View
Grid View
Grouping data
Filtering records
Working in multi-level mode
Create Grid Level Wizard
Specify master level
Select table or query for new level
Bind master and detail levels
Specify additional parameters
Viewing data in card view
Form View
Print Data
Blob View
Navigating with the BLOB Editor
Editing as hexadecimal dump
Editing as plain text
Editing as rich text (RTF)
Editing as image
Editing as HTML
Applying changed
Filter Builder Dialog
Invoking the Filter Builder dialog
Adding new condition
Setting filter criteria
Setting filter operator
Setting filter criteria values
Adding new group
Setting group operator
Applying filter conditions
Database Tools
Visual Database Designer
Using navigation bar
Navigating on diagram
Adding objects to diagram
Removing objects from diagram
New objects creation
Creating relationships
Working with multiple pages
Reverse engineering
Printing diagram
Print Preview Dialog
Print Setup Dialog
Saving/Loading diagram
Setting diagram options
SQL Script Editor
Using navigation bar
Using popup menu
Using script explorer
Extract Database Wizard
Selecting source database
Specifying destination file name
Selecting components to extract
Selecting objects to extract their structure
Selecting objects to extract their data
Customizing script options
Print Metadata
Using navigation bar
Printing options
HTML Report Wizard
Select database and directory
Select type of database objects
Specify report style
Set additional parameters
Report management
Create Report Wizard
Specifying report name and options
Selecting report bands
Selecting report style
Specifying page options
Report Designer
Adding dialog form
Adding database component
Adding query component
Specifying fields
Viewing report
Report Viewer
Using navigation bar
SQL Monitor
Using navigation bar
Using popup menu
Dependency Tree
Monitor of Tables Altering...
Search in Metadata
Events List
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 options
Data format
Fields
Options
Styles
Extensions
Hyperlinks
Notes
Charts
Cells
Merged Cells
Advanced
Access options
Word / RTF options
Base Styles
Strip Styles
HTML options
Preview
Basic
Multi-file
Advanced
PDF options
TXT options
CSV options
XML options
Setting common export options
Export As SQL Script Wizard
Specifying destination server
Setting destination file name
Selecting field to export
Editing result SQL script
Setting export options
Import Data Wizard
Selecting source file name and format
Selecting data source
Setting fields correspondence