Description

Trying to rename myschema.mytable to myschema.othername

The command should be:
exec sp_rename "myschema.mytable", "othername";
instead of
exec sp_rename "myschema"."mytable", "othername";

HeidiSQL version

12.8.0.6908

Database server version

MSSQL 2022

Error/Backtrace

No response

Reproduction recipe

Go to ...
Click on ....
See error message: ...