<< Get to know Firebird in 2 minutes | Documentation | Firebird Internals >>


Firebird 2 Cheat Sheet

Author: Lorenzo Alberton, http://www.alberton.info




Firebird SQL Cheat Sheet - details

The cheat sheet is organized in 5 sections. The first section contains a list of the available datatypes, their description and the range of values that each of them supports.

The second section contains a list of the internal functions. The ones listed here are the Firebird 2 built-in functions; they're grouped by field of interest (aggregate, conditional, string functions).

The third section contains a list of the Default UDF functions. Firebird bundles an UDF library with some useful functions not included in the core. These functions are listed here, grouped by field of interest (mathematical and string functions).

The fourth section contains some useful queries, like the most useful queries to manage TRANSACTIONs, SAVEPOINTs, SEQUENCEs, a sample query with a LIMIT / OFFSET clause, and some queries against the System Tables to retrieve a list of the tables, fields, indices and constraints.

The last section holds a list of the PHP ibase_* functions. PHP has a Firebird/Interbase module and this is used by PHP developers to connect to, and query, a Firebird database. This section lists the functions available in PHP for connecting to and managing a Firebird database.

You can download the cheat sheet here or view at Lorenzo's website: http://www.alberton.info/firebird_cheat_sheet.html

back to top of page
<< Get to know Firebird in 2 minutes | Documentation | Firebird Internals >>

Any comments? Send an email to documentation@ibexpert.com
COPYRIGHT 2002-2017 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 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. All Microsoft brand and product names are trademarks or registered trademarks of Microsoft 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.