isql Command Reference

Go Up to Interactive Query

This chapter describes the syntax and usage for commands available only in InterBase isql (interactive SQL). These commands are also available in SQL scripts. For a description of the standard DSQL commands available in isql, see the Language Reference Guide.

Command-line isql supports the following special commands:

isql Commands

BLOBDUMP	SET BLOBDISPLAY	SHELL	SHOW INDEX
EDIT	SET COUNT	SHOW CHECK	SHOW INDICES
EXIT	SET ECHO	SHOW DATABASE	SHOW PROCEDURES
HELP	SET LIST	SHOW DOMAINS	SHOW ROLES
INPUT	SET NAMES	SHOW EXCEPTIONS	SHOW SYSTEM
OUTPUT	SET PLAN	SHOW FILTERS	SHOW TABLES
QUIT	SET STATS	SHOW FUNCTIONS	SHOW TRIGGERS
SET	SET TERM	SHOW GENERATORS	SHOW VERSION
SET AUTODDL	SET TIME	SHOW GRANT	SHOW VIEWS

Topics

• BLOBDUMP
• EDIT
• EXIT
• HELP
• INPUT
• OUTPUT
• QUIT
• SET
• SET AUTODDL
• SET BLOBDISPLAY
• SET COUNT
• SET ECHO
• SET LIST
• SET NAMES
• SET PLAN
• SET STATS
• SET TIME
• SHELL
• SHOW CHECK
• SHOW DATABASE
• SHOW DOMAINS
• SHOW EXCEPTIONS
• SHOW FILTERS
• SHOW FUNCTIONS
• SHOW GENERATORS
• SHOW GRANT
• SHOW INDEX
• SHOW PROCEDURES
• SHOW ROLES
• SHOW SYSTEM
• SHOW TABLES
• SHOW TRIGGERS
• SHOW VERSION
• SHOW VIEWS