Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Additional Features to Enhance DataServer Performance : Modifying the run-time schema check
 

Modifying the run-time schema check

At runtime, the DataServer for MS SQL Server performs a schema check to match a table definition in the data source against the schema image in the schema holder. It performs this task once for each table utilized in a OpenEdge procedure. In order to retrieve table attributes without having to access data, the DataServer executes the following SQL statement against the data source:
SELECT * FROM table-name WHERE 1 = 2.
* Skip schema verification