Release 10.1A: OpenEdge Data Management:
SQL Development

> ## Comparing OpenEdge SQL and Progress 4GL database objects

> ##### Rows and columns

> A SQL database table is made up of rows and columns. A row is a single occurrence of data in a table. A column characterizes one attribute of a row of data. The Progress 4GL uses the term “field” instead of “column” and “record” instead of “row.”

> ##### Tables

> A SQL table is a group of related data composed of rows and columns. The term “table” is used similarly in the Progress 4GL to describe a collection of fields and records.

> ##### Schemas

> The term schema can be used three different ways:

> - When discussing a database created with OpenEdge SQL, a schema is defined as a collection of related database objects, such as tables or views. A SQL database can contain several schemas.

> - When referring to a database created with the Progress 4GL, schema is defined as the area in which all system and user information are stored. A Progress 4GL database contains only one schema area, referred to as the PUB (short for PUBLIC) schema.

> - While working from the OpenEdge SQL client, you can ensure you are working in the correct schema by using the `SET SCHEMA` command. For more information on using `SET SCHEMA`, see OpenEdge Data Management: SQL Reference .

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095