Disable a check of foreign key constraint on a table.
Disable-Constraint [-TableName] <String> [-SchemaName <String>] [-Name] <String> [<CommonParameters>]The Disable-Constraint operation disables a check or foreign key constraint on a table. Only check and foreign key constraints can be enabled/disabled.
| Name | Type | Description | Required? | Pipeline Input | Default Value |
|---|---|---|---|---|---|
| TableName | String | The name of the constraint's table. |
true | false | |
| SchemaName | String | The schema of the table. Default is |
false | false | dbo |
| Name | String | The name of the constraint. |
true | false |
Disable-CheckConstraint 'Migrations' 'CK_Migrations_MigrationID'Demonstrates how to disable a constraint on a table. In this case, the CK_Migrations_MigrationID constraint on the Migrations table is disabled. Is it a check constraint? Foreign key constraint? It doesn't matter!