SQL-DMO
NotForRepl Property
The NotForRepl property enables or disables an IDENTITY constraint for data inserted by a replication process.
Applies To
| Column Object |
Syntax
object.NotForRepl [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write when using the Column object to create or alter a SQL Server table. Read-only when the Column object references an existing column.
Prototype (C/C++)
HRESULT GetNotForRepl(LPBOOL pRetVal);
HRESULT SetNotForRepl(BOOL NewValue);
Remarks
If TRUE, the IDENTITY constraint is not enforced when data is added to the table by a known replication login. The replication process provides identity values.
If FALSE, the IDENTITY constraint is enforced regardless of the data source.