SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mytable (id int, test int)
exec sp_rename 'mytable.test', 'mytable.test2'
Caution: Changing any part of an object name could break scripts and stored procedures.


select *
from mytable


id
mytable.test2


exec sp_rename 'mytable."mytable.test2"', 'test2'
Caution: Changing any part of an object name could break scripts and stored procedures.


exec sp_rename 'mytable."mytable.test2"', 'test2'
Msg 15225 Level 11 State 1 Line 436
No item by the name of 'mytable."mytable.test2"' could be found in the current database 'fiddle_cd7612525be74431bd382203d2e64d66', given that @itemtype was input as '(null)'.