ALTER SCHEMA Stage TRANSFER dbo.Stage_AAA;

EXEC sp_rename 'Stage.Stage_AAA', 'AAA';

USE [MyDB]

GO

IF EXISTS(SELECT * FROM sys.columns WHERE name = N'Column' AND object_id = object_id('[dbo].[Table]'))

BEGIN

  EXEC sp_rename '[dbo].[Table].[Column]', 'Column1', 'COLUMN'

END