dbo.DPRSystemVariable
Defines the variables used by a synchronization project. The table is handled by the SynchronizationEditor. Do not make any changes here.
TableType TUsage USERDATARows 28SizeMB 0.048
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DPRSystemVariable | varchar(38) | no | System variable | PKUID |
Name | nvarchar(512) | yes | Name | |
DisplayName | nvarchar(512) | yes | Display name | |
NameFormat | nvarchar(64) | yes | Name format | |
Value | nvarchar(-1) | yes | Value | |
Description | nvarchar(2048) | yes | Description | |
XObjectKey | varchar(138) | no | Object key | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
UID_DPRSystemVariableSet | varchar(38) | no | Variable set | FKUID |
UID_QBMClrType | varchar(38) | no | CLR type | FKUID |
IsSecret | bit(1) | yes | Contains sensible data | |
IsSystemVariable | bit(1) | yes | Is system variable | |
GenerateValueScript | nvarchar(-1) | yes | GenerateValueScript | |
ScriptLanguage | nvarchar(32) | yes | Script language | limited |
IsMultiLine | bit(1) | yes | Multiline |
Relations
| FK | From | To |
|---|---|---|
| DPR_RFRL2478 | DPRSystemVariable.UID_QBMClrType | QBMClrType.UID_QBMClrType |
Triggers
GEN_T159CDDF6B74BAE39740E29C01 SQL_TRIGGER
GEN_T2F3AB1B0FE854E66AC63B6CB4 SQL_TRIGGER
GEN_T32B6552A73D99C952D9AED24C SQL_TRIGGER
GEN_T4D5102DD0CE52350BE91AEEE6 SQL_TRIGGER
GEN_T5EE7AE7737C5B4DAC3B8D7D19 SQL_TRIGGER
GEN_T69BB914F90D4F40E38B79856F SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.GEN_T13371B79AFC07E3D85A0E6931 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ABAE3443DC53DD3EC1BBAC13 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T39F1E8AA12558B27224F1C08D | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMClrType | referenced by foreign key from table | DPR_RFRL2478: DPRSystemVariable.UID_QBMClrType -> QBMClrType.UID_QBMClrType |