InterBase Quick Start

From InterBase
Jump to: navigation, search

Go Up to Main Page


This Quick Start tutorial takes you step-by-step through the process of creating and using a database. You learn to create data structures that enforce referential integrity constraints and maintain security. You populate your tables, create triggers and stored procedures, and learn a number of techniques for retrieving the data with precision. Instructions assume that you use the interactive SQL window of the IBConsole but you may use the command-line isql instead. If you use the command-line isql, you may need to modify the provided code.

IBConsole

InterBase provides an intuitive graphical user interface called IBConsole. With IBConsole you can perform all the necessary tasks to configure and maintain an InterBase server, to create and administer databases on the server, and to execute interactive SQL (isql). IBConsole only runs on Windows, but can manage databases on any server on the local network. For more information about the IBConsole environment, see the IBConsole reference topics. For more information about how to use IBConsole and related tools, see Using IBConsole and Tools.

Command-line isql Tool

Command-line isql is a utility for processing SQL data definition (DDL) and data manipulation (DML) statements from interactive input or from a source file. It enables you to create and view metadata, add and modify data, grant user permissions, test queries, and perform database administration tasks.

For a description of the standard SQL commands available in isql, see the Language Reference Guide. For a description of special isql commands, see isql Command Reference.

Topics

Personal tools
Previous Releases:
In other languages