NotForRepl Property (SQL-DMO)

The NotForRepl property enables or disables an IDENTITY constraint for data inserted by a replication process.

Applies To

Column Object

Syntax

object.NotForRepl [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value True or False

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 source of the data.

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);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.