18.1 Introduction

This chapter is applicable to UNIX LispWorks and the Enterprise Edition of LispWorks. It describes Common SQL -- the LispWorks interface to SQL. It should be used in conjunction with the relevant chapter of the LispWorks Reference Manual , which contains full reference entries for all the symbols in the SQL package.

For a longer introduction to Common SQL, please see the SQL Tutorial available at .

This chapter covers the following areas:

The LispWorks SQL interface uses the following database terminology:

Data Definition Language (DDL)

The language used to specify and interrogate the structure of the database schema.

Data Manipulation Language (DML)

The language used for retrieving and modifying data. Also known as query language .


A set of records. Also known as relation .


A field of information in the table. Also known as column .


A complete set of attribute values in the table. Also known as tuple , or row .


A display of a table configured to your own needs. Also known as virtual table .

18.1.1 Overview

18.1.2 Supported databases

LispWorks User Guide - 8 Apr 2005