SQL language reference

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.

• Comparison operators
• Data retrieval
• Data transaction
• DCL - Data Control Language
• DDL - Data Definition Language
• DML - Data Manipulation Language
• Firebird SQL
• JOIN
• Query
• SQL dialect
• Stored procedure and trigger language
• Structured Query Language
• Symbols and brackets used in code syntax

back to top of page

Any comments? Send an email to register@ibexpert.biz

COPYRIGHT © 2002-2022 HK-Software, IBExpert Ltd. All rights reserved.

All IBExpert brand and product names are trademarks or registered trademarks of IBExpert Ltd 
in Malta and other countries. InterBase, Delphi, CodeGear and C++Builder are trademarks or
 registered trademarks of Embarcadero Technologies Inc. in the United States and other countries. 
 Firebird is a registered trademark of the FirebirdSQL Foundation. Turbo Pascal is a registered 
 trademark of Borland International, Inc. Sun, Java, JavaScript and Solaris are trademarks or 
 registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and 
 other countries. UNIX is a registered trademark in the United States and other countries, 
 exclusively licensed through "The Open Group". Oracle is a registered trademark of Oracle 
 Corporation in the United States and other countries. All Microsoft brand and product names 
 are trademarks or registered trademarks of Microsoft Corporation in the United States and 
 other countries. AS/400, DB2, IBM, Informix and iSeries are trademarks or registered trademarks 
 of IBM Corporation in the United States and other countries. Linux is a registered trademark of 
 Linux Torvalds. All other product names mentioned herein and throughout the entire web site are 
 trademarks of their respective owners.