Enable a check or foreign key constraint.
Enable-Constraint [-TableName] <String> [-SchemaName <String>] [-Name] <String> [<CommonParameters>]The Enable-Constraint operation enables 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 |
Enable-Constraint 'Migrations' 'FK_Migrations_MigrationID'Demonstrates how to disable a constraint on a table. In this case, the FK_Migrations_MigrationID constraint on the Migrations table is disabled. Is it a check constraint? Foreign key constraint? It doesn't matter!