Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL and Advanced Business Language Interoperability : ABL and OpenEdge SQL interaction in an OpenEdge application : Comparing OpenEdge SQL and ABL database objects : 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 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.