Share via


Check.NotForReplication Property

Gets the Boolean property value that specifies whether the check constraint is available for replication or not.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Deploy)> _
Public Property NotForReplication As Boolean 
    Get 
    Set
'Usage
Dim instance As Check 
Dim value As Boolean 

value = instance.NotForReplication

instance.NotForReplication = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)]
public bool NotForReplication { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Deploy)]
public:
property bool NotForReplication {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)>]
member NotForReplication : bool with get, set
function get NotForReplication () : boolean 
function set NotForReplication (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the check constraint is available for replication or not. By default, the value is unspecified.If True, the check constraint is not available for replication.If False (default), the check constraint is available for replication.

Remarks

Note

For check constraints based on the UserDefinedTableType object this property is always treated as false. If the NotForReplication property is set the value is ignored.

Examples

Setting Properties

See Also

Reference

Check Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Working with Database Objects

CHECK Constraints

CREATE TABLE (Transact-SQL)