ForeignKey.IsChecked Property

Gets or sets the Boolean property value that specifies whether the foreign key constraint was enabled without checking existing 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 ForeignKey 
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 foreign key constraint was enabled without checking existing rows.If True, the foreign key constraint was enabled without checking existing rows.If False (default), all rows were checked when the foreign key constraint was enabled.

Remarks

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

Examples

Creating, Altering, and Removing Foreign Keys

See Also

Reference

ForeignKey Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Creating and Modifying FOREIGN KEY Constraints

CREATE TABLE (Transact-SQL)