The modObjectTypes Table

See Also

The modObjectTypes table is a lookup table that enforces object types and associates a description and caption with an object type.

The modObjectTypes database table contains a number of columns used by the team solutions. The following table lists those columns and their data types and provides a brief description of each.

Column Data type Description
Type char(2) Type of object:

DM   = 
main user table
VM   = 
main database view
DD   = 
detail user table
VD   = 
detail database view
DL   = 
lookup table
DR   = 
relation table
DX   = 
other user tables
WF   = 
workflow table
PR   = 
permission table
SP   = 
stored procedure
TR   = 
trigger
CL   = 
code library

Caption nvarchar(256) A text description of the object type.
rowguid uniqueidentifier Unique identifier used for replication.