Share via


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)

Syntax

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

value = instance.IsChecked

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

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.

Remarks

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

Note

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

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)