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 ABL, schema is defined as the area in which all system and user information are stored. An ABL 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.