The OpenEdge database and the MS SQL Server database share the structural elements common to relational databases, but each system has its own elements. These elements, called database or data source objects, are components of the OpenEdge database or MS SQL Server databases's logical structure. The following table lists OpenEdge database objects and the MS SQL Server database equivalents.

Table 1. OpenEdge Database objects and MS SQL Server database objects
OpenEdge MS SQL Server
Table/File Table
Field Column
Record Row
Index Index
Unique index Primary key
Nonunique index Foreign key
Sequences Native equivalent1
Validation expression Integrity constraint
Validation message No equivalent
Initial value Default
View View
No equivalent to stored procedures Stored procedure
Schema Trigger Trigger
1 The DataServer supports OpenEdge sequences through native stored procedures and triggers.