Table Of Contents

• Welcome to Rapid SQL
  • Prerequisites and Preliminary Tasks
    • Introducing Rapid SQL
    • Technical Requirements
    • DBMS Support and Connectivity Options
    • Installing and Licensing Rapid SQL
      • Installing Rapid SQL
      • Licensing Your Product
        • Licensing Overview
        • Licensing Your Application
        • Selecting a License Category During Startup
        • Online/Offline Mode and Concurrent License Checkout
    • Quick Start Setup
    • More Information on Using this Document
      • Accessing Third Party Documentation
      • Shorthand for Third Party Product References
• What's New in Rapid SQL 18.2
  • What Was New in Past Releases
    • What's New in Rapid SQL XE6 Patch
      • Release Notes for Rapid SQL XE6 Patch
    • What's New in Rapid SQL XE6
    • What's New in Rapid SQL XE5
    • What's New in Rapid SQL XE4
    • What's New in Rapid SQL XE3.5
• What's New in Rapid SQL 18.1.x
• What's New in Rapid SQL 18.0
• What's New in Rapid SQL 17.1.x
• What's New in Rapid SQL 17.0.x
  • Release Notes
• What's New in Rapid SQL 16.6.x
  • Release Notes for Rapid SQL 2016+
  • Release Notes
• What's New in Rapid SQL 2016+
• What's New in Rapid SQL 2016
  • Release Notes for Rapid SQL 2016 Patch
• Getting Started
  • Starting Rapid SQL
    • Starting an Installed version of Rapid SQL from the Start Menu
    • Starting an Installed version of Rapid SQL from the Command Line
  • Rapid SQL Application Basics
    • Rapid SQL Product Design
      • The Rapid SQL Datasource Navigator
      • Rapid SQL Toolbars
      • Rapid SQL Windows
      • Rapid SQL Menus
      • Customizing the Rapid SQL General User Interface Appearance
      • Rapid SQL Keyboard Shortcuts
      • Rapid SQL Full Screen Mode
    • Error Report
  • Rapid SQL Tutorial exercises
    • Session 1: Getting Started
      • Starting the Rapid SQL Application
      • Registering Cross-Platform Datasources to Rapid SQL
    • Session 2: Productivity Enhancers
      • The Datasource Navigator Tree
      • Creating an Object Using the Object Creation Wizard
      • Working With an Existing Object Using the Object Editor
      • Object Documentation and Reporting
      • Working With Code, Files and Data
      • Setting Environment Options
      • Script Library
      • Working with Scripts and Files
      • Viewing Data
      • Retaining Datasource Navigator View Settings
      • Datasource Navigator Bookmarks
      • Setting Keyboard Shortcuts and Hotkeys
      • Referencing Most Recently Used Datasources
    • Session 3: Scripting
      • Generating Code
      • Right-click feature
      • Automated error detection and coding assistance
      • Other coding aids
    • Session 4: Working with Code Workbench
    • Session 5: Building a Database Project
    • Session 6: Visual Query Builder
    • Session 7: Live Data Editor
    • Session 8: Code Analyst
    • Session 9: SQL Debugging and Profiling
      • SQL Debugging
      • SQL Profiling- Oracle Only
  • Specifying Application Preferences and Feature Options
    • Configuring Feature Options
      • Browsers Options
      • Code Analyst Options
      • Connection Options
      • Data Editor Options
      • Data Transfer Options
      • Datasource Options
      • DBMS Java Options
      • DB2 Utilities Options
      • DDL Extract Options
      • Debug Options
      • Directories Options
      • Explorer Options
      • General Options
      • Grid Properties (Results window) Options
      • ISQL Options
      • Java Options
      • LDAP Configuration Options
      • Logging Options
      • MySQL Utilities Options
      • Oracle Utilities Options
      • Query Builder Options
      • Reports Options
      • Results (ISQL) Options
      • Mail Options
      • Version Control Options
      • Warnings Options
    • Locking Down Features Using the Registry
• Datasource and Server Management
  • Registering Datasources
    • Specifying a Datasource Catalog Storage Option
    • Manually Registering or Editing Datasources
      • Selecting Database Type/Connectivity Options When Registering Datasources
      • Providing Connection Information When Registering Datasources
      • Providing Security Parameters When Registering Datasources
      • Providing Custom Driver Properties When Registering Datasources
      • Specifying Datasource Properties When Registering Datasources
      • Specifying Oracle Views Configuration When Registering Datasources
      • Specifying Group and Category Details When Registering Datasources
    • Automatically Discovering Datasources
      • Setting up to Automatically Discover Datasources
      • Discovering Datasources on First Application Startup
      • Manually Discovering Datasources
    • Importing and Exporting Datasource Definitions
    • Viewing Datasource Properties
    • Unregistering Datasources
  • Connecting to Datasources
    • Connecting to a Datasource From the Navigator
    • Disconnecting from a Datasource
    • Connecting to Datasources from an Alphabetical Listing
  • Trouble-shooting Client Setup
  • Using the Datasource Navigator
    • Customizing the Navigator Displays
      • Basic Viewing Options in the Navigator
      • Categorizing Datasources using Color-coding and Labeling
      • Filtering in the Navigator
      • Working with Datasource Groups
    • Connected/Selected Datasource options
    • Filtering columns in Database Object Displays
    • Working with Bookmarks
    • Working with Supplementary Organizer Tabs
      • Using the Script Library
    • Hiding and Displaying the Datasource Navigator
    • Initiating Object Actions in the Navigator
  • Using the Manage Datasources Utility
• Database Object Management
  • Supported Objects
    • Aliases
    • Asymmetric Keys
    • Audit Policies
    • Certificates
    • Chains
    • Check Constraints
    • Clusters
    • Database Links
    • Database Triggers
    • Databases
      • IBM DB2 for Linux, Unix, and Windows Instances
      • Microsoft SQL Server Databases
      • IBM DB2 for OS/390 and z/OS Instances
      • Sybase ASE Databases
    • Defaults
    • Directories
    • Domains
    • Events
    • Exclusion Constraints
    • Extended Procedures
    • Foreign Keys
    • Full-text Catalogs
    • Full-text Indexes
    • Functions
    • Groups
    • Indexes
      • Missing Indexes (SQL Server)
      • IBM DB2 for Linux, Unix, and Windows Indexes
      • IBM DB2 for OS/390 and z/OS Indexes
      • Microsoft SQL Server Indexes
      • Oracle Indexes
      • Sybase ASE Indexes
    • Instance
    • Java Classes
    • Java Resources
    • Java Sources
    • Jobs (Oracle)
    • Job Queues
    • Join Indexes
    • Libraries
    • Logins
    • Materialized Query Tables
    • Materialized Views
    • Materialized View Logs
    • Outlines
    • Package Bodies
    • Packages
    • Partition Functions
    • Partition Schemes
    • Plans
    • Primary Keys
    • Procedures
    • Profiles
    • Programs
    • Recycle Bin
    • Resource Plans
    • Roles
      • Microsoft SQL Server Roles
      • Oracle Roles
    • Rules
    • Schedules
    • Schema
    • Segments
    • Sequences
    • Structured Types
    • Symmetric Keys
    • Synonyms
    • System Indexes
    • System Tables
    • System Triggers
    • Tables
    • Tablespaces
    • Triggers
    • Type Bodies
    • Types
    • Unified Auditing
    • Unique Keys
    • User Datatypes
    • User Messages
    • Users
    • Views
  • Creating objects
    • Overview and Common Usage of Object Wizards
      • Opening an Object Wizard
      • Navigating and Setting Properties in an Object Wizard
      • Adding a Comment to an Object
      • Setting Permissions or Privileges for an Object
      • Previewing the DDL Generated to Create the New Object
    • IBM DB2 for Linux, Unix, and Windows Object Wizards
      • Aliases Wizard (DB2 LUW)
      • Databases Wizard (DB2 LUW)
      • Foreign Keys Wizard (DB2 LUW)
      • Functions Wizard (DB2 LUW)
      • Indexes Wizard (DB2 LUW)
      • Materialized Query Tables Wizard (DB2 LUW)
      • Nodegroups Wizard (DB2 LUW)
      • Primary Keys Wizard (DB2 LUW)
      • Procedures Wizard (DB2 LUW)
      • Schemas Wizard (DB2 LUW)
      • Sequences Wizard (DB2 LUW)
      • Structured Types Wizard (DB2 LUW)
      • Tables Wizard (DB2 LUW)
      • Tablespaces Wizard (DB2 LUW)
      • Triggers Wizard (DB2 LUW)
      • Unique Keys Wizard (DB2 LUW)
      • User Datatypes (DB2 LUW)
      • Users Wizard (DB2 LUW)
      • Views Wizard (DB2 LUW)
    • IBM DB2 for z/OS Object Wizards
      • Aliases Wizard (DB2 Z/OS)
      • Databases Wizard (DB2 Z/OS)
      • Foreign Keys Wizard (DB2 Z/OS))
      • Functions Wizard (DB2 Z/OS)
      • Indexes Wizard (DB2 Z/OS)
      • Plans Wizard (DB2 Z/OS)
      • Primary Keys Wizard (DB2 Z/OS)
      • Procedures Wizard (DB2 Z/OS)
      • Stogroups Wizard (DB2 Z/OS)
      • Synonyms Wizard (DB2 Z/OS)
      • Tables Wizard (DB2 Z/OS)
      • Tablespaces Wizard (DB2 Z/OS)
      • Triggers Wizard (DB2 Z/OS)
      • Unique Keys Wizard (DB2 Z/OS)
      • User Datatypes Wizard (DB2 Z/OS)
      • Users Wizard (DB2 Z/OS)
      • Views Wizard (DB2 Z/OS)
    • Microsoft SQL Server Object Wizards
      • Asymmetric Keys Wizard (SQL Server)
      • Certificate Wizard (SQL Server)
      • Check Constraint Wizard (SQL Server)
      • Column Encryption Key Wizard (SQL Server)
      • Column Master Key Wizard (SQL Server)
      • Databases Wizard (SQL Server)
      • Database Triggers Wizard (SQL Server)
      • Defaults Wizard (SQL Server)
      • Extended Procedures Wizard (SQL Server)
      • Foreign Keys Wizard (SQL Server)
      • Full-text Catalogs Wizard (SQL Server)
      • Full-text Indexes Wizard (SQL Server)
      • Functions Wizard (SQL Server)
      • Indexes Wizard (SQL Server)
      • Logins Wizard (SQL Server)
      • Partition Functions Wizard (SQL Server)
      • Partition Schemes Wizard (SQL Server)
      • Primary Keys Wizard (SQL Server)
      • Procedures Wizard (SQL Server)
      • Roles Wizard (SQL Server)
      • Rules Wizard (SQL Server)
      • Schema Wizard (SQL Server)
      • Sequences Wizard (SQL Server)
      • Symmetric Keys Wizard (SQL Server)
      • Synonyms Wizard (SQL Server)
      • Tables Wizard (SQL Server)
      • Triggers Wizard (SQL Server)
      • Unique Keys Wizard (SQL Server)
      • User Messages Wizard (SQL Server)
      • Users Wizard (SQL Server)
      • User Datatypes Wizard (SQL Server)
      • Views Wizard (SQL Server)
    • Oracle Object Wizards
      • Clusters Wizard (Oracle)
      • Database Links Wizard (Oracle)
      • Directories Wizard (Oracle)
      • Foreign Keys Wizard (Oracle)
      • Functions Wizard (Oracle)
      • Grouped Policy Wizard (Oracle)
      • Indexes Wizard (Oracle)
      • Oracle Job Queue Wizard (Oracle)
      • Jobs wizard (Oracle)
      • Libraries Wizard (Oracle)
      • Materialized Views Wizard (Oracle)
      • Materialized View Logs Wizard (Oracle)
      • Outlines Wizard (Oracle)
      • Packages Wizard (Oracle)
      • Policy Context Wizard (Oracle)
      • Primary Keys Wizard (Oracle)
      • Procedures Wizard (Oracle)
      • Profiles Wizard (Oracle)
      • Programs wizard (Oracle)
      • Roles Wizard (Oracle)
      • Rollback Segments Wizard (Oracle)
      • Schedules Wizard (Oracle)
      • Sequences Wizard (Oracle)
      • Snapshots and Snapshot Logs Wizards (Oracle)
      • Synonyms Wizard (Oracle)
      • Tables Wizard (Oracle)
      • Tablespaces Wizard (Oracle)
      • Triggers Wizard (Oracle)
      • Object Types Wizard (Oracle)
      • Unified Audit Policy Wizard (Oracle)
      • Unique Keys Wizard (Oracle)
      • Users Wizard (Oracle)
      • Views Wizard (Oracle)
    • PostgreSQL Object Wizards
      • Check Constraints Wizard (PostgreSQL)
      • Domains Wizard (PostgreSQL)
      • Exclusion Constraints, Primary Keys, and Unique Keys Wizards (PostgreSQL)
      • Foreign Keys Wizard (PostgreSQL)
      • Functions Wizard (PostgreSQL)
      • Indexes Wizard (PostgreSQL)
      • Roles Wizard (PostgreSQL)
      • Rules Wizard (PostgreSQL)
      • Schemas Wizard (PostgreSQL)
      • Tables Wizard (PostgreSQL)
      • Tablespaces Wizard (PostgreSQL)
      • Triggers Wizard (PostgreSQL)
      • Types Wizard (PostgreSQL)
      • Views Wizard (PostgreSQL)
    • Sybase ASE Object Wizards
      • Aliases Wizard (Sybase ASE)
      • Databases Wizard (Sybase ASE)
      • Defaults Wizard (Sybase ASE)
      • Extended Procedures Wizard (Sybase ASE)
      • Foreign Keys Wizard (Sybase ASE)
      • Functions Wizard (Sybase ASE)
      • Groups Wizard (Sybase ASE)
      • Indexes Wizard (Sybase ASE)
      • Logins Wizard (Sybase ASE)
      • Primary Keys Wizard (Sybase ASE)
      • Procedures Wizard (Sybase ASE)
      • Rules Wizard (Sybase ASE)
      • Segment Wizard (Sybase ASE)
      • Tables Wizard (Sybase ASE)
      • Triggers Wizard (Sybase ASE)
      • Unique Keys Wizard (Sybase ASE)
      • User Datatypes Wizard (Sybase ASE)
      • User Messages Wizard (Sybase ASE)
      • Users Wizard (Sybase ASE)
      • Views Wizard (Sybase ASE)
  • Modifying objects using editors
    • Overview and common usage of object editors
      • Opening an Object Editor
      • Viewing and Modifying Object Properties
      • Previewing and Submitting Object Editor Changes
    • IBM DB2 for Linux, Unix, and Windows Object Editors
      • Aliases Editor (IBM DB2 LUW)
      • Check Constraints Editor (IBM DB2 LUW)
      • Databases Editor (IBM DB2 LUW)
      • Foreign Keys Editor (IBM DB2 LUW)
      • Functions Editor (IBM DB2 LUW)
      • Indexes Editor (IBM DB2 LUW)
      • Materialized Query Tables Editor (IBM DB2 LUW)
      • Packages Editor (IBM DB2 LUW)
      • Primary Keys Editor (IBM DB2 LUW)
      • Procedures Editor (IBM DB2 LUW)
      • Sequences Editor (IBM DB2 LUW)
      • Structured Types Editor (IBM DB2 LUW)
      • Tables Editor (IBM DB2 LUW)
      • Tablespaces Editor (IBM DB2 LUW)
      • Triggers Editor (IBM DB2 LUW)
      • Unique Keys Editor (IBM DB2 LUW)
      • User Datatypes Editor (IBM DB2 LUW)
      • Users Editor (IBM DB2 LUW)
      • Views Editor (IBM DB2 LUW)
    • IBM DB2 for z/OS Object Editors
      • Aliases Editor (IBM DB2 Z/OS)
      • Check Constraints Editor (IBM DB2 Z/OS)
      • Databases Editor (IBM DB2 Z/OS)
      • Foreign Keys Editor (IBM DB2 Z/OS)
      • Functions Editor (IBM DB2 Z/OS)
      • Indexes Editor (IBM DB2 Z/OS)
      • Packages Editor (IBM DB2 Z/OS)
      • Plans Editor (IBM DB2 Z/OS)
      • Primary Keys Editor (IBM DB2 Z/OS)
      • Procedures Editor (IBM DB2 Z/OS)
      • Stogroups Editor (IBM DB2 Z/OS)
      • Synonyms Editor (IBM DB2 Z/OS)
      • Tables Editor (IBM DB2 Z/OS)
      • Tablespaces Editor (IBM DB2 Z/OS)
      • Triggers Editor (IBM DB2 Z/OS)
      • Unique Keys Editor (IBM DB2 Z/OS)
      • User Datatypes Editor (IBM DB2 Z/OS)
      • Users Editor (IBM DB2 Z/OS)
      • Views Editor (IBM DB2 Z/OS)
    • Microsoft SQL Server Object Editors
      • Asymmetric Keys Editor (SQL Server)
      • Certificates Editor (SQL Server)
      • Check Constraints Editor (SQL Server)
      • Databases Editor (SQL Server)
      • Database Triggers Editor (SQL Server)
      • Defaults Editor (SQL Server)
      • Extended Procedures Editor (SQL Server)
      • Foreign Keys Editor (SQL Server)
      • Full-text Catalogs Editor (SQL Server)
      • Full-text Indexes Editor (SQL Server)
      • Functions Editor (SQL Server)
      • Indexes Editor (SQL Server)
      • Logins Editor (SQL Server)
      • Partition Functions Editor (SQL Server)
      • Partition Schemes Editor (SQL Server)
      • Primary Keys Editor (SQL Server)
      • Procedures Editor (SQL Server)
      • Roles Editor (SQL Server)
      • Rules Editor (SQL Server)
      • Schemas Editor (SQL Server)
      • Sequences Editor (SQL Server)
      • Symmetric Key Editor (SQL Server)
      • Synonyms Editor (SQL Server)
      • Tables Editor (SQL Server)
      • Triggers Editor (SQL Server)
      • Unique Keys Editor (SQL Server)
      • Users Editor (SQL Server)
      • User Datatypes Editor (SQL Server)
      • User Messages Editor (SQL Server)
      • Views Editor (SQL Server)
    • MySQL editors
      • Database editor (MySQL)
      • Foreign Keys editor (MySQL)
      • Functions editor (MySQL)
      • Indexes, Primary Keys, and Unique Keys editors (MySQL)
      • Tables editor (MySQL)
      • Users editor (MySQL)
    • Oracle Object Editors
      • Check Constraints Editor (Oracle)
      • Clusters Editor (Oracle)
      • Database Links Editor (Oracle)
      • Directories Editor (Oracle)
      • Foreign Keys Editor (Oracle)
      • Functions Editor (Oracle)
      • Indexes Editor (Oracle)
      • Job Queue Editor (Oracle)
      • Jobs Editor (Oracle)
      • Libraries Editor (Oracle)
      • Materialized Views Editor (Oracle)
      • Materialized View Logs Editor (Oracle)
      • Outlines Editor (Oracle)
      • Package Bodies Editor (Oracle)
      • Packages Editor (Oracle)
      • Primary Keys Editor (Oracle)
      • Procedures Editor (Oracle)
      • Programs Editor (Oracle)
      • Profiles Editor (Oracle)
      • Redo Log Groups Editor (Oracle)
      • Roles Editor (Oracle)
      • Rollback Segments Editor (Oracle)
      • Schedules Editor (Oracle)
      • Sequences Editor (Oracle)
      • Synonyms Editor (Oracle)
      • Tables Editor (Oracle)
      • Tablespaces Editor (Oracle)
      • Triggers Editor (Oracle)
      • Type Bodies Editor (Oracle)
      • Types Editor (Oracle)
      • Unique Keys Editor (Oracle)
      • Users Editor (Oracle)
      • Views Editor (Oracle)
      • Partitioning Oracle indexes, primary keys, and unique keys
    • PostgreSQL Object Editors
      • Check Constraints Editor (PostgreSQL)
      • Domains Editor (PostgreSQL)
      • Exclusion Constraints, Primary Keys, or Unique Keys Editors (PostgreSQL)
      • Foreign Keys Editor (PostgreSQL)
      • Functions Editor (PostgreSQL)
      • Indexes Editor (PostgreSQL)
      • Roles Editor (PostgreSQL)
      • Rules Editor (PostgreSQL)
      • Schemas Editor (PostgreSQL)
      • Tables Editor (PostgreSQL)
      • Tablespaces Editor (PostgreSQL)
      • Triggers Editor (PostgreSQL)
      • Types Editor (PostgreSQL)
      • Views Editor (PostgreSQL)
    • Sybase ASE Object Editors
      • Aliases Editor (Sybase ASE)
      • Check Constraints Editor (Sybase ASE)
      • Databases Editor (Sybase ASE)
      • Defaults Editor (Sybase ASE)
      • Extended Procedures Editor (Sybase ASE)
      • Foreign Keys Editor (Sybase ASE)
      • Functions Editor (Sybase ASE)
      • Groups Editor (Sybase ASE)
      • Indexes Editor (Sybase ASE)
      • Logins Editor (Sybase ASE)
      • Primary Keys Editor (Sybase ASE)
      • Procedures Editor (Sybase ASE)
      • Rules Editor (Sybase ASE)
      • Segments Editor (Sybase ASE)
      • Tables Editor (Sybase ASE)
      • Triggers Editor (Sybase ASE)
      • Unique Keys Editor (Sybase ASE)
      • User Datatypes Editor (Sybase ASE)
      • User Messages Editor (Sybase ASE)
      • Users Editor (Sybase ASE)
      • Views Editor (Sybase ASE)
    • MySQL object wizards
      • Databases wizard (MySQL)
      • Foreign Keys wizard (MySQL)
      • Functions wizard (MySQL)
      • Indexes, Primary Keys, or Unique Keys wizard (MySQL)
      • Tables wizard (MySQL)
      • Users wizard (MySQL)
  • Object actions
    • Overview of object actions/operations execution
      • Initiating an object operation
      • Using object operation wizards
    • Available object actions by DBMS
      • Add or Modify Check Constraint
      • Add/Modify Login Trigger
      • Add Private Key
      • Allocate Extent
      • Analyze
      • Analyze Tables
      • Attach Database
      • Backup Certificate
      • Bind Package
      • Bind To Temporary Database
      • Build
      • Build Query
      • Change Access Status
      • Change Category
      • Change Password
      • Change Status
      • Check Tables
      • Checkpoint
      • Checksum Tables
      • Coalesce
      • Compile
      • Convert Tables
      • Copy Object Names
      • Copy Schema
      • Create Alias
      • Create Clone
      • Create Insert Statements
      • Create Like
      • Create Synonym
      • Create View
      • DBCC
      • Deallocate Unused Space
      • Delete Statistics
      • Describe
      • Detach Database
      • Disable Index
      • Disable Job
      • Disable Keys
      • Disable/Enable Triggers
      • Drop
      • Drop Automatic Storage Path(s)
      • Drop By Category
      • Drop Clone
      • Drop Java
      • Drop Login Trigger
      • Drop Materialized Query Table
      • Drop Unused
      • Enable Job (Job Queue)
      • Enable Keys
      • Enable Recycle Bin
      • Enable/Disable (Oracle Jobs)
      • Estimate Size
      • Exchange Data With Clone
      • Execute
      • Extract
      • Extract Data as XML
      • Flashback Recycle Bin Entry
      • Flashback Table
      • Flush Cache
      • Flush Tables
      • Free (Packages)
      • Free Plan
      • Generate Package/Procedure/Statement
      • Hide Text
      • Import Data From File
      • Load Java
      • Lock
      • Lower High Water Mark
      • Move Log
      • Move Table
      • Next Used Filegroup
      • Object Properties
      • Optimize Tables
      • Place
      • Population status
      • Purge Recycle Bin
      • Purge Recycle Bin Entry
      • Quiesce
      • Reassign By Category
      • Rebalance
      • Rebind Packages
      • Rebind Plans
      • Rebuild (Full-text Catalogs)
      • Rebuild Index
      • Rebuild Outlines
      • Rebuild Table
      • Recompile
      • Refresh Materialized View
      • Refresh Table
      • Rename
      • Reorganize /Reorg
      • Repair Tables
      • Report
      • Restart (Object Action)
      • Restart Sequence(s)
      • Resynchronize
      • Run Job (Oracle Jobs)
      • Run Job (job queues)
      • Role Activation
      • Schema (Object Action)
      • Select * From
      • Set Default
      • Set Integrity
      • Set Online/Offline
      • Set UNDO
      • Shrink
      • Start Database
      • Stop Database
      • Stop Job
      • Switch Online
      • Transfer Ownership
      • Truncate
      • Unbind From Temporary Database
      • Update Statistics
      • Change Owner
      • Enable/Disable Filetable(s)
      • Unquiesce
      • Enable/Disable Stored Outline Auto-creation/Auto-use
      • Change Schema
      • Edit Data
      • Error
      • Create or Edit Java Source
• Coding Environments/Editors
  • Common Word-processing Operations
    • Clipboard Functions
      • Cutting/Copying and Pasting Columns
    • File operations
      • Opening Files
      • Inserting a File Into an Open Script
      • Saving and Closing Scripts
    • Find/Replace Options in Coding Environments
    • Regular Expressions Support
    • Changing Case
    • Printing Options
  • Common Coding Environment Features
  • Using the SQL Editor
    • SQL Editor Windows Basics
      • SQL Editor Toolbar Options
      • ISQL Window Status Bar
    • Valid Content in the SQL Editor
      • Bind Variable Parameterization in Prepared Statements (Dynamic SQL)
      • SQL Preprocessing: #define and #include
      • ETStart and ETEnd tags
    • Automated Error Detection and Coding Aid Features
      • Syntax Checking
      • Semantic Validation
      • Code Complete
      • Hyperlink Object Actions
      • Paste SQL Syntax
      • Paste SQL Statements
      • Using Code Templates
      • Using Auto Replace Expressions
      • Toggling Display of the Error Pane
      • ISQL Performance
    • Execution and Execution-related SQL Editor options
      • Locking a SQL Editor Window to a Datasource
      • Setting up the Execution Environment with Query options
      • Executing Entire Scripts in the SQL Editor
      • Executing Partial Scripts in the SQL Editor
      • Executing the Current Statement
      • Step Executing a Script
      • Using the Query Plan Facility
      • Canceling a Query
    • Using the Results Editor
      • Results Window Toolbar Options
      • Configuring Result Set Windows
      • Configuring Results Window Grid Properties
      • Exporting Data to Other Products
      • Setting Result Windows to Read-only Mode
      • Result Window Status Bar
      • Mailing Result Sets
      • Renaming and Closing Query Window Tabs
      • Closing Result Window Tabs
      • Saving and Closing Result Sets
      • Editing Result Sets
      • Formatting Result Sets
      • Notes on XML Types and Unicode Display in the Results Editor
    • Miscellaneous SQL Editor Tasks
  • Using the DDL Editor
• Tools
  • Find in Files
  • Database Search
  • Script/File Execution Facilities
  • Scheduling
  • Visual Difference
    • Setting Visual Difference options
    • Specifying the Files or Database Objects to Compare
    • Navigating to the next or previous highlighted difference
    • Finding character strings in the source or target
    • Printing a Pane of the Visual Difference Dialog Box
  • Query Builder
    • Query Builder Design
      • Query Builder Dialog Boxes
      • Workspace Windows
      • Query Builder Toolbar
      • Tables and Views Shortcut Menus
      • Tables and Views Keyboard Commands
    • Using Query Builder
      • Main Steps in Using Query Builder
      • Building a Query
      • Working with Tables and Views in the SQL Diagram Pane
      • Working with Columns in the SQL Diagram Pane
      • Selecting ALL or DISTINCT Columns
      • Joins
      • Auto Layout
      • Auto Joins
      • Creating a Clause Using the SQL Statement Tree
      • Subqueries
      • Syntax Checker
      • Saving and Reopening Queries
      • Using Data Editor with Query Builder
  • Code Analyst (Tools Menu )
  • Code Generation Facility
  • Import Data
  • SQL Profiler
  • Table/Index Size Estimator
  • IDERA Product Menu Commands
  • Available DBMS Utility Menu Commands
  • Code Workbench
    • Working with Code Workbench Auto Replace Shortcuts
      • Enabling Auto Replace Shortcut Substitution
      • Configuring Auto Replace Shortcuts
      • Using Code Workbench Auto Replace Shortcuts in the ISQL Window
    • Importing and Exporting Settings in Code Workbench
    • Working With Code Workbench Code Templates
      • Enabling Code Templates
      • Defining the Hot Key for the Code Templates Dialog Box
      • Creating Code Templates
      • Using Code Templates in the SQL Editor
  • Customize (Tools menu)
  • Options (Tools menu)
  • Data Editor
    • Using Data Editor
• Project Management
  • Project support
    • Create a New Project
      • Create a New Project From a Database
      • Create a New Project From Existing Files
      • Create a New Project From a Version Control Project
      • Create a New Project Without Initialization
      • New Project Dialog Box
    • Working With Projects
      • Opening an Existing Project
      • Opening a Recent Project
      • Closing a Project
      • Build Project
      • Set Build Order
      • Add Database Object File(s) to Project Wizard
      • Execute Project Files
      • Add File(s) to a Project
      • Open a File from a Project
      • Subfolders
      • Project Properties
  • Version Control
    • Working with Projects in Version Control
    • Version Control Functionality - Check Out
    • Version Control Functionality - Check In
    • Version Control Functionality - Undo Check Out
    • Version Control Functionality - Delete
    • VC Files Tab
      • Working with Files in Version Control
      • Version Control Functionality - Refresh
      • Version Control Functionality - Collapse All
      • Version Control Functionality - Close Files List
      • Version Control Functionality - Expand All
    • Version Control Functionality - Sort
    • Version Control Functionality - Remove from Version Control
    • Version Control Functionality - Show History
    • Version Control Properties
    • Version Control Functionality - Show Differences
    • Version Control Functionality - Open
    • Version Control Functionality - Get Latest Version
• Add-on tools
  • Code Analyst
    • Code Analyst DBMS Notes
    • Code Analyst Requirements
    • Installing Code Analyst
    • Uninstalling Code Analyst
    • Code Analyst Product Design
    • Code Analyst Tutorial
    • Using the Code Analyst
      • Creating a Code Analyst Session
      • Identifying and Fixing Bottlenecks Using Code Analyst
      • Comparing Code Analyst Sessions
      • Cloning a Code Analyst Session
      • Deleting a Code Analyst Session
      • Stopping a Code Analyst Session Execution
      • Executing a Code Analyst Session
      • Scheduling a Code Analyst Session
      • Unscheduling a Code Analyst Session
      • Refreshing a Code Analyst Session
      • Saving Results in Code Analyst
      • Printing Results in Code Analyst
      • Viewing Run Details in Code Analyst
      • Viewing Unit Summary Information in Code Analyst
      • Viewing Unit Details in Code Analyst
      • Setting View Options for the Unit Detail Tab in Code Analyst
      • Extracting SQL Text in Code Analyst
      • Executing SQL in Code Analyst
  • PL/SQL Profiler
    • Setting up PL/SQL Profiler
    • PL/SQL Profiler Explorer
    • PL/SQL Profiler Functionality
      • Start
      • Flush
      • Run Summary
      • Run Detail
      • Unit Summary
      • Clear Profile Table
      • Unit Detail
      • Stop (PL/SQL Profiler)
    • Using PL/SQL Profiler
      • Sample Profiling Session
  • IDERA SQL Debugger
    • SQL Debugger Modules and DBMS Support
    • IDERA SQL Debugger Features
    • Setting up the IDERA SQL Debugger
      • IDERA SQL Debugger for Linux, Unix, and Windows Setup
      • The IDERA SQL Debugger for Microsoft Setup
      • IDERA SQL Debugger for Oracle Setup
      • IDERA SQL Debugger Options
    • IDERA SQL Debugger Interface
      • DDL Editor Window
      • Watch Window
      • Variables Window
      • Call Stack Window
      • Dependency Tree Window
    • IDERA SQL Debugger Functionality
      • Go
      • Input Parameters
      • Restart
      • Run To Cursor
      • Break
      • Step Over
      • Step Into
      • Insert or Remove Breakpoint
      • Stop
      • Toggle Breakpoint
      • Step Out
      • Close
    • Using the IDERA SQL Debugger
      • Opening a Debugging Session
      • Debugging an SQL Script with IDERA SQL Debugger
    • Tutorial Sessions
      • Debugging a Sample Script with IDERA SQL Debugger for Microsoft
      • Debugging a Sample Script with IDERA SQL Debugger for Oracle
• Index
• What's New in Rapid SQL 17.0