Named default constraint removal incorrectly targets temporal history table

### Bug description

When a named default constraint is removed from a property on a SQL Server temporal table, EF Core generates a migration that attempts to drop the constraint from both the current table and its history table.

The constraint exists only on the current table, so applying the migration fails with SQL Server error 3728:
```
'DF_MyEntity_Seq' is not a constraint.
Could not drop constraint. See previous errors.
```

The generated SQL incorrectly contains:
```sql
ALTER TABLE [MY_ENTITYHistory] DROP CONSTRAINT [DF_MyEntity_Seq];
```


Reproduction steps:
1. Create the model with `.HasDefaultValue(1, "DF_MyEntity_Seq")`.
2. Run `dotnet ef migrations add Create`.
3. Remove `.HasDefaultValue(1, "DF_MyEntity_Seq")`.
4. Run `dotnet ef migrations add RemoveDefaultConstraint`.
5. Run `dotnet ef database update`.

The generated migration contains:
```csharp
migrationBuilder.AlterColumn<int>(
    name: "Seq",
    table: "MY_ENTITY",
    type: "int",
    nullable: false,
    oldClrType: typeof(int),
    oldType: "int",
    oldDefaultValue: 1)
    .OldAnnotation("Relational:DefaultConstraintName", "DF_MyEntity_Seq");
```

Generated sql:
```sql
ALTER TABLE [MY_ENTITY] SET (SYSTEM_VERSIONING = OFF);

ALTER TABLE [MY_ENTITY] DROP CONSTRAINT [DF_MyEntity_Seq];
ALTER TABLE [MY_ENTITY] ALTER COLUMN [Seq] int NOT NULL;

ALTER TABLE [MY_ENTITYHistory] DROP CONSTRAINT [DF_MyEntity_Seq];
ALTER TABLE [MY_ENTITYHistory] ALTER COLUMN [Seq] int NOT NULL;

ALTER TABLE [MY_ENTITY] SET (SYSTEM_VERSIONING = ON (...));
```

### Your code

```csharp
using Microsoft.EntityFrameworkCore;

public class MyEntity
{
    public int Id { get; set; }
    public int Seq { get; set; }
}

public class MyContext : DbContext
{
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer(...);
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        var builder = modelBuilder.Entity<MyEntity>();

        builder.ToTable("MY_ENTITY", table => table.IsTemporal());
        builder.HasKey(entity => entity.Id);

        builder.Property(entity => entity.Seq)
            .HasDefaultValue(1, "DF_MyEntity_Seq")
            .IsRequired();
    }
}
```

### Stack traces

```text
Microsoft.Data.SqlClient.SqlException (0x80131904): 'DF_MyEntity_Seq' is not a constraint.
Could not drop constraint. See previous errors.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite)
   at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.Execute(IReadOnlyList`1 migrationCommands, IRelationalConnection connection, MigrationExecutionState executionState, Boolean beginTransaction, Boolean commitTransaction, Nullable`1 isolationLevel)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.<>c.<ExecuteNonQuery>b__3_1(DbContext _, ValueTuple`6 s)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IReadOnlyList`1 migrationCommands, IRelationalConnection connection, MigrationExecutionState executionState, Boolean commitTransaction, Nullable`1 isolationLevel)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.MigrateImplementation(DbContext context, String targetMigration, MigrationExecutionState state, Boolean useTransaction)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.<>c.<Migrate>b__20_1(DbContext c, ValueTuple`4 s)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
ClientConnectionId:3998806e-23b9-40ec-a8e8-7a592cd47bb4
Error Number:3728,State:1,Class:16
'DF_MyEntity_Seq' is not a constraint.
Could not drop constraint. See previous errors.
```

### Verbose output

```text
E:\Temp\EfBug\EfTemporalDefaultConstraint ❯ dotnet ef --version                                                                                                                                                                07:52:19
Entity Framework Core .NET Command-line Tools
10.0.11
E:\Temp\EfBug\EfTemporalDefaultConstraint ❯ dotnet ef migrations add Create                                                                                                                                                    07:52:32
Build started...
Build succeeded.
Done. To undo this action, use 'ef migrations remove'
E:\Temp\EfBug\EfTemporalDefaultConstraint ❯ dotnet ef migrations add RemoveDefaultConstraint --verbose                                                                                                                         07:52:43
Using project 'E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj'.
Using startup project 'E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj'.
dotnet msbuild /getProperty:ProjectName /getProperty:AssemblyName /getProperty:DesignAssembly /getProperty:Language /getProperty:OutputPath /getProperty:PlatformTarget /getProperty:ProjectAssetsFile /getProperty:ProjectDir /getProperty:RootNamespace /getProperty:RuntimeFrameworkVersion /getProperty:TargetFileName /getProperty:TargetFrameworkMoniker /getProperty:Nullable /getProperty:TargetFramework /getProperty:TargetPlatformIdentifier /getProperty:Platform /t:ResolvePackageAssets /getItem:RuntimeCopyLocalItems E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj
dotnet msbuild /getProperty:ProjectName /getProperty:AssemblyName /getProperty:DesignAssembly /getProperty:Language /getProperty:OutputPath /getProperty:PlatformTarget /getProperty:ProjectAssetsFile /getProperty:ProjectDir /getProperty:RootNamespace /getProperty:RuntimeFrameworkVersion /getProperty:TargetFileName /getProperty:TargetFrameworkMoniker /getProperty:Nullable /getProperty:TargetFramework /getProperty:TargetPlatformIdentifier /getProperty:Platform /t:ResolvePackageAssets /getItem:RuntimeCopyLocalItems E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj
Build started...
dotnet build E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj /verbosity:quiet /nologo /p:PublishAot=false

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:01.34

Build succeeded.
dotnet exec --depsfile E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0\EfTemporalDefaultConstraint.deps.json --additionalprobingpath T:\NuGet\.nuget --additionalprobingpath "C:\Program Files (x86)\Microsoft Visual Studio\Shared\NuGetPackages" --runtimeconfig E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0\EfTemporalDefaultConstraint.runtimeconfig.json T:\NuGet\.nuget\dotnet-ef\10.0.11\tools\net8.0\any\tools\net8.0\any\ef.dll migrations add RemoveDefaultConstraint --assembly E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0\EfTemporalDefaultConstraint.dll --project E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj --startup-assembly E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0\EfTemporalDefaultConstraint.dll --startup-project E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj --project-dir E:\Temp\EfBug\EfTemporalDefaultConstraint\ --root-namespace EfTemporalDefaultConstraint --language C# --framework net10.0 --design-assembly T:\NuGet\.nuget\microsoft.entityframeworkcore.design\10.0.11\lib\net10.0\Microsoft.EntityFrameworkCore.Design.dll --nullable --working-dir E:\Temp\EfBug\EfTemporalDefaultConstraint --verbose
Using assembly 'EfTemporalDefaultConstraint'.
Using startup assembly 'EfTemporalDefaultConstraint'.
Using application base 'E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0'.
Using working directory 'E:\Temp\EfBug\EfTemporalDefaultConstraint'.
Using root namespace 'EfTemporalDefaultConstraint'.
Using project directory 'E:\Temp\EfBug\EfTemporalDefaultConstraint\'.
Remaining arguments: .
Finding DbContext classes...
Using environment 'Development'.
Finding IDesignTimeDbContextFactory implementations...
Finding DbContext classes in the project...
Found DbContext 'MyContext'.
Finding application service provider in assembly 'EfTemporalDefaultConstraint'...
Finding Microsoft.Extensions.Hosting service provider...
No static method 'CreateHostBuilder(string[])' was found on class 'Program'.
No application service provider was found.
Using context 'MyContext'.
Finding design-time services referenced by assembly 'EfTemporalDefaultConstraint'...
Finding design-time services referenced by assembly 'EfTemporalDefaultConstraint'...
No referenced design-time services were found.
Finding design-time services for provider 'Microsoft.EntityFrameworkCore.SqlServer'...
Using design-time services from provider 'Microsoft.EntityFrameworkCore.SqlServer'.
Finding IDesignTimeServices implementations in assembly 'EfTemporalDefaultConstraint'...
No design-time services were found.
Writing migration to 'E:\Temp\EfBug\EfTemporalDefaultConstraint\Migrations\20260821055307_RemoveDefaultConstraint.cs'.
Writing model snapshot to 'E:\Temp\EfBug\EfTemporalDefaultConstraint\Migrations\MyContextModelSnapshot.cs'.
'MyContext' disposed.
Done. To undo this action, use 'ef migrations remove'
E:\Temp\EfBug\EfTemporalDefaultConstraint ❯ dotnet ef database update --verbose                                                                                                                                                07:53:07
Using project 'E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj'.
Using startup project 'E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj'.
dotnet msbuild /getProperty:ProjectName /getProperty:AssemblyName /getProperty:DesignAssembly /getProperty:Language /getProperty:OutputPath /getProperty:PlatformTarget /getProperty:ProjectAssetsFile /getProperty:ProjectDir /getProperty:RootNamespace /getProperty:RuntimeFrameworkVersion /getProperty:TargetFileName /getProperty:TargetFrameworkMoniker /getProperty:Nullable /getProperty:TargetFramework /getProperty:TargetPlatformIdentifier /getProperty:Platform /t:ResolvePackageAssets /getItem:RuntimeCopyLocalItems E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj
dotnet msbuild /getProperty:ProjectName /getProperty:AssemblyName /getProperty:DesignAssembly /getProperty:Language /getProperty:OutputPath /getProperty:PlatformTarget /getProperty:ProjectAssetsFile /getProperty:ProjectDir /getProperty:RootNamespace /getProperty:RuntimeFrameworkVersion /getProperty:TargetFileName /getProperty:TargetFrameworkMoniker /getProperty:Nullable /getProperty:TargetFramework /getProperty:TargetPlatformIdentifier /getProperty:Platform /t:ResolvePackageAssets /getItem:RuntimeCopyLocalItems E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj
Build started...
dotnet build E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj /verbosity:quiet /nologo /p:PublishAot=false

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:01.36

Build succeeded.
dotnet exec --depsfile E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0\EfTemporalDefaultConstraint.deps.json --additionalprobingpath T:\NuGet\.nuget --additionalprobingpath "C:\Program Files (x86)\Microsoft Visual Studio\Shared\NuGetPackages" --runtimeconfig E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0\EfTemporalDefaultConstraint.runtimeconfig.json T:\NuGet\.nuget\dotnet-ef\10.0.11\tools\net8.0\any\tools\net8.0\any\ef.dll database update --assembly E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0\EfTemporalDefaultConstraint.dll --project E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj --startup-assembly E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0\EfTemporalDefaultConstraint.dll --startup-project E:\Temp\EfBug\EfTemporalDefaultConstraint\EfTemporalDefaultConstraint.csproj --project-dir E:\Temp\EfBug\EfTemporalDefaultConstraint\ --root-namespace EfTemporalDefaultConstraint --language C# --framework net10.0 --design-assembly T:\NuGet\.nuget\microsoft.entityframeworkcore.design\10.0.11\lib\net10.0\Microsoft.EntityFrameworkCore.Design.dll --nullable --working-dir E:\Temp\EfBug\EfTemporalDefaultConstraint --verbose
Using assembly 'EfTemporalDefaultConstraint'.
Using startup assembly 'EfTemporalDefaultConstraint'.
Using application base 'E:\Temp\EfBug\EfTemporalDefaultConstraint\bin\Debug\net10.0'.
Using working directory 'E:\Temp\EfBug\EfTemporalDefaultConstraint'.
Using root namespace 'EfTemporalDefaultConstraint'.
Using project directory 'E:\Temp\EfBug\EfTemporalDefaultConstraint\'.
Remaining arguments: .
Finding DbContext classes...
Using environment 'Development'.
Finding IDesignTimeDbContextFactory implementations...
Finding DbContext classes in the project...
Found DbContext 'MyContext'.
Finding application service provider in assembly 'EfTemporalDefaultConstraint'...
Finding Microsoft.Extensions.Hosting service provider...
No static method 'CreateHostBuilder(string[])' was found on class 'Program'.
No application service provider was found.
Using context 'MyContext'.
Finding design-time services referenced by assembly 'EfTemporalDefaultConstraint'...
Finding design-time services referenced by assembly 'EfTemporalDefaultConstraint'...
No referenced design-time services were found.
Finding design-time services for provider 'Microsoft.EntityFrameworkCore.SqlServer'...
Using design-time services from provider 'Microsoft.EntityFrameworkCore.SqlServer'.
Finding IDesignTimeServices implementations in assembly 'EfTemporalDefaultConstraint'...
No design-time services were found.
Creating DbConnection.
Created DbConnection. (17ms).
Migrating using database 'IDIS_INR' on server 'devmachine,1460'.
Opening connection to database 'IDIS_INR' on server 'devmachine,1460'.
Opened connection to database 'IDIS_INR' on server 'devmachine,1460'.
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (4ms).
Initialized DbCommand for 'ExecuteNonQuery' (8ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
Executed DbCommand (16ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
Closing connection to database 'IDIS_INR' on server 'devmachine,1460'.
Closed connection to database 'IDIS_INR' on server 'devmachine,1460' (3ms).
Opening connection to database 'IDIS_INR' on server 'devmachine,1460'.
Opened connection to database 'IDIS_INR' on server 'devmachine,1460'.
Acquiring an exclusive lock for migration application. See https://aka.ms/efcore-docs-migrations-lock for more information if this takes too long.
Creating DbCommand for 'ExecuteScalar'.
Created DbCommand for 'ExecuteScalar' (0ms).
Initialized DbCommand for 'ExecuteScalar' (1ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
DECLARE @result int;
EXEC @result = sp_getapplock @Resource = '__EFMigrationsLock', @LockOwner = 'Session', @LockMode = 'Exclusive';
SELECT @result
Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
DECLARE @result int;
EXEC @result = sp_getapplock @Resource = '__EFMigrationsLock', @LockOwner = 'Session', @LockMode = 'Exclusive';
SELECT @result
Beginning transaction with isolation level 'Unspecified'.
Began transaction with isolation level 'ReadCommitted'.
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (0ms).
Initialized DbCommand for 'ExecuteNonQuery' (1ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
IF OBJECT_ID(N'[__EFMigrationsHistory]') IS NULL
BEGIN
    CREATE TABLE [__EFMigrationsHistory] (
        [MigrationId] nvarchar(150) NOT NULL,
        [ProductVersion] nvarchar(32) NOT NULL,
        CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])
    );
END;
Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
IF OBJECT_ID(N'[__EFMigrationsHistory]') IS NULL
BEGIN
    CREATE TABLE [__EFMigrationsHistory] (
        [MigrationId] nvarchar(150) NOT NULL,
        [ProductVersion] nvarchar(32) NOT NULL,
        CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])
    );
END;
Committing transaction.
Committed transaction.
Disposing transaction.
Beginning transaction with isolation level 'Unspecified'.
Began transaction with isolation level 'ReadCommitted'.
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (0ms).
Initialized DbCommand for 'ExecuteNonQuery' (0ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1
Creating DbCommand for 'ExecuteScalar'.
Created DbCommand for 'ExecuteScalar' (0ms).
Initialized DbCommand for 'ExecuteScalar' (0ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
Creating DbCommand for 'ExecuteReader'.
Created DbCommand for 'ExecuteReader' (0ms).
Initialized DbCommand for 'ExecuteReader' (0ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId];
Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId];
Closing data reader to 'IDIS_INR' on server 'devmachine,1460'.
A data reader for 'IDIS_INR' on server 'devmachine,1460' is being disposed after spending 1ms reading results.
Applying migration '20260821055243_Create'.
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (0ms).
Initialized DbCommand for 'ExecuteNonQuery' (0ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
DECLARE @historyTableSchema nvarchar(max) = QUOTENAME(SCHEMA_NAME())
EXEC(N'CREATE TABLE [MY_ENTITY] (
    [Id] int NOT NULL IDENTITY,
    [Seq] int NOT NULL CONSTRAINT [DF_MyEntity_Seq] DEFAULT 1,
    [PeriodEnd] datetime2 GENERATED ALWAYS AS ROW END HIDDEN NOT NULL,
    [PeriodStart] datetime2 GENERATED ALWAYS AS ROW START HIDDEN NOT NULL,
    CONSTRAINT [PK_MY_ENTITY] PRIMARY KEY ([Id]),
    PERIOD FOR SYSTEM_TIME([PeriodStart], [PeriodEnd])
) WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = ' + @historyTableSchema + N'.[MY_ENTITYHistory]))');
Executed DbCommand (8ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
DECLARE @historyTableSchema nvarchar(max) = QUOTENAME(SCHEMA_NAME())
EXEC(N'CREATE TABLE [MY_ENTITY] (
    [Id] int NOT NULL IDENTITY,
    [Seq] int NOT NULL CONSTRAINT [DF_MyEntity_Seq] DEFAULT 1,
    [PeriodEnd] datetime2 GENERATED ALWAYS AS ROW END HIDDEN NOT NULL,
    [PeriodStart] datetime2 GENERATED ALWAYS AS ROW START HIDDEN NOT NULL,
    CONSTRAINT [PK_MY_ENTITY] PRIMARY KEY ([Id]),
    PERIOD FOR SYSTEM_TIME([PeriodStart], [PeriodEnd])
) WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = ' + @historyTableSchema + N'.[MY_ENTITYHistory]))');
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (0ms).
Initialized DbCommand for 'ExecuteNonQuery' (0ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20260821055243_Create', N'10.0.11');
Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20260821055243_Create', N'10.0.11');
Committing transaction.
Committed transaction.
Disposing transaction.
Applying migration '20260821055307_RemoveDefaultConstraint'.
Beginning transaction with isolation level 'Unspecified'.
Began transaction with isolation level 'ReadCommitted'.
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (0ms).
Initialized DbCommand for 'ExecuteNonQuery' (0ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
ALTER TABLE [MY_ENTITY] SET (SYSTEM_VERSIONING = OFF)
Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
ALTER TABLE [MY_ENTITY] SET (SYSTEM_VERSIONING = OFF)
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (0ms).
Initialized DbCommand for 'ExecuteNonQuery' (0ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
ALTER TABLE [MY_ENTITY] DROP CONSTRAINT [DF_MyEntity_Seq];
ALTER TABLE [MY_ENTITY] ALTER COLUMN [Seq] int NOT NULL;
Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
ALTER TABLE [MY_ENTITY] DROP CONSTRAINT [DF_MyEntity_Seq];
ALTER TABLE [MY_ENTITY] ALTER COLUMN [Seq] int NOT NULL;
Creating DbCommand for 'ExecuteNonQuery'.
Created DbCommand for 'ExecuteNonQuery' (0ms).
Initialized DbCommand for 'ExecuteNonQuery' (1ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
ALTER TABLE [MY_ENTITYHistory] DROP CONSTRAINT [DF_MyEntity_Seq];
ALTER TABLE [MY_ENTITYHistory] ALTER COLUMN [Seq] int NOT NULL;
Failed executing DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
ALTER TABLE [MY_ENTITYHistory] DROP CONSTRAINT [DF_MyEntity_Seq];
ALTER TABLE [MY_ENTITYHistory] ALTER COLUMN [Seq] int NOT NULL;
Disposing transaction.
Creating DbCommand for 'ExecuteScalar'.
Created DbCommand for 'ExecuteScalar' (0ms).
Initialized DbCommand for 'ExecuteScalar' (0ms).
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
DECLARE @result int;
EXEC @result = sp_releaseapplock @Resource = '__EFMigrationsLock', @LockOwner = 'Session';
SELECT @result
Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
DECLARE @result int;
EXEC @result = sp_releaseapplock @Resource = '__EFMigrationsLock', @LockOwner = 'Session';
SELECT @result
Closing connection to database 'IDIS_INR' on server 'devmachine,1460'.
Closed connection to database 'IDIS_INR' on server 'devmachine,1460' (0ms).
'MyContext' disposed.
Disposing connection to database 'IDIS_INR' on server 'devmachine,1460'.
Disposed connection to database '' on server '' (1ms).
Microsoft.Data.SqlClient.SqlException (0x80131904): 'DF_MyEntity_Seq' is not a constraint.
Could not drop constraint. See previous errors.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite)
   at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.Execute(IReadOnlyList`1 migrationCommands, IRelationalConnection connection, MigrationExecutionState executionState, Boolean beginTransaction, Boolean commitTransaction, Nullable`1 isolationLevel)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.<>c.<ExecuteNonQuery>b__3_1(DbContext _, ValueTuple`6 s)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IReadOnlyList`1 migrationCommands, IRelationalConnection connection, MigrationExecutionState executionState, Boolean commitTransaction, Nullable`1 isolationLevel)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.MigrateImplementation(DbContext context, String targetMigration, MigrationExecutionState state, Boolean useTransaction)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.<>c.<Migrate>b__20_1(DbContext c, ValueTuple`4 s)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
ClientConnectionId:af141af9-0406-486d-b26a-94b047c30e66
Error Number:3728,State:1,Class:16
'DF_MyEntity_Seq' is not a constraint.
Could not drop constraint. See previous errors.
```

### EF Core version

10.0.11

### Database provider

Microsoft.EntityFrameworkCore.SqlServer 10.0.11

### Target framework

.NET 10.0

### Operating system

Windows 11

### IDE

Microsoft Visual Studio Professional 2026 18.8.2

Navigation Menu

Uh oh!

Named default constraint removal incorrectly targets temporal history table #38836

Bug description

Your code

Stack traces

Verbose output

EF Core version

Database provider

Target framework

Operating system

IDE

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Uh oh!

Named default constraint removal incorrectly targets temporal history table #38836

Description

Bug description

Your code

Stack traces

Verbose output

EF Core version

Database provider

Target framework

Operating system

IDE

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions