Export (0) Print
Expand All

Check.IsChecked Property

Gets the Boolean property value that specifies whether the constraint was enabled without checking existing rows, so constraint may not hold for all rows

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

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Matrix)]
public bool IsChecked { get; set; }

Property Value

Type: Boolean
A Boolean value that specifies whether the check constraint was enabled without checking existing rows. If True, the check constraint was enabled without checking existing rows.If False (default), existing rows were checked when the check constraint was enabled.

If the IsChecked property is True, the constraint might not hold for all rows.

NoteNote

For check constraints based on the UserDefinedTableType object this property is always true because the user-defined data type cannot be modified.

Community Additions

ADD
Show:
© 2014 Microsoft