isql Commands

Go Up to Command-line isql Tool

At the SQL> prompt, you can enter any of three kinds of commands:

• SQL data definition (DDL) statements, such as CREATE, ALTER, DROP, GRANT, and REVOKE. These statements create, modify, or remove metadata and objects, and control user access (via privileges) to the database. For more information about DDL, see the Data Definition Guide.
• SQL data manipulation (DML) statements such as SELECT, INSERT, UPDATE, and DELETE. These four data manipulation operations affect the data in a database. They retrieve, modify, add, or delete data. For more information about DML statements, see the Language Reference.
• isql commands that fall into three main categories:

• SHOW commands (to display metadata or other database information)
• SET commands (to modify the isql environment)
• Other commands (for example, commands to read an input file, write to an output file, or end an isql session)

Some isql commands have many options. See isql Command Reference

Topics

• SHOW Commands
• SET Commands
• Other isql Commands
• QUIT and EXIT Cmmands