Progress
DataServer for
Microsoft SQL Server
Guide


Progress Database Objects and MSS Database Objects

The Progress database and the 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 Progress database or MSS databases’s logical structure. Table 2–1 lists Progress database objects and the MSS database equivalents.

Table 2–1: ProgressDatabase Objects and MSS Database Objects
Progress
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
Schema trigger
Trigger
No equivalent to stored procedures
Stored procedure
View
View
  1. The DataServer supports Progress sequences through native stored procedures and triggers.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095