Firebird Documentation Index → Isql - Interactive SQL
Firebird Home Firebird Home Firebird Documentation IndexNext: Overview

Firebird Interactive SQL Utility

Kamala Vadlamani

Paul Vinkenoog

Extensive review and many changes.

Norman Dunbar

Firebird 2.x updates, conversion to stand alone manual.

10 April 2013 – Document version 0.5

Table of Contents

Introduction
Overview
Invoking Isql
Command Line Switches
Starting An Isql Session
Ending An Isql Session
Getting Help
Connecting To A Database
Creating A Database
Setting The ISC_USER And ISC_PASSWORD Environment Variables
SQL Dialects
Terminator Character
Isql Prompts
Error Handling And Exception Support
Transaction Handling
Script Handling
Isql Commands
Isql Set Commands
Isql Show commands
A. Document History
B. License Notice

Introduction

Audience
Version

This manual provides reference material for the Firebird Interactive SQL Utility (isql), and instructions on how to use it to perform tasks within the database.

Warning

This manual is a work in progress. It is subject to change and possible restructuring as new versions appear.

Audience

This manual assumes prior knowledge of basic database concepts.

Version

This manual describes the isql utility in Firebird version 1.5 and higher.

Firebird Documentation IndexNext: Overview
Firebird Documentation Index → Isql - Interactive SQL