Interactive Query

Go Up to Operations Guide

This chapter documents the IBConsole interactive SQL (isql) and command-line isql utilities for InterBase. These tools provide an interface to InterBase Dynamic SQL interpreter. You can use these query tools to perform data definition, prototype queries before implementing them in your application, or to perform ad hoc examination of data in your database.

Topics

• The IBConsole isql Window
• Managing isql Temporary Files
• Executing SQL Statements
• Using Batch Updates to Submit Multiple Statements
• Changing isql Settings
• Inspecting Database Objects
• Command-line isql Tool
• isql Command Reference
• Using SQL Scripts