This topic has not yet been rated - Rate this topic

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)]
public bool IsChecked { get; set; }

Property Value

Type: System.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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.