OpenEdge database objects and MS SQL Server database objects

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 5. 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 equivalent¹
Validation expression	Integrity constraint
Validation message	No equivalent
Initial value	Default
View	View
No equivalent to stored procedures	Stored procedure
Schema Trigger	Trigger

¹ The DataServer supports OpenEdge sequences through native stored procedures and triggers.