Here is some basic information regarding DDL, DML and stored procedure and trigger language. Refer to the InterBase SQL Language Reference handbook for detailed information concerning InterBase syntax, and we recommend Helen Borrie's book, the Firebird Book - a Reference for Database Developers, for detailed information concerning Firebird 1.5. A complete Firebird SQL Reference can be found here at these documentation sites: Firebird 2 Language Reference Update, Firebird 2.1 Language Reference Update and Firebird 2.5 Language Reference Update.
Please also refer to the IBExpert Tools menu: Script Executive / Script Language Extensions for IBExpert's own invaluable extensions, and the IBEBlock documentation. IBEBlock is a set of DDL, DML and other statements which include some specific constructions applicable only in IBExpert or IBEScript.
Context-sensitive help for all SQL keywords can be started directly from all IBExpert text editors using the [F1] key.
- Structured Query Language
- SQL dialect
- Symbols and brackets used in code syntax
- Comparison operators
- Firebird SQL
- Data retrieval
- DML - Data Manipulation Language
- DDL - Data Definition Language
- Data transaction
- DCL - Data Control Language
- Stored procedure and trigger language
Any comments? Send an email to firstname.lastname@example.org
COPYRIGHT © 2002-2016 HK-Software, IBExpert GmbH. All rights reserved.