Rename a column if it exists in a table

Question

I am trying to rename a column if it is exists

GO

IF EXISTS(SELECT 1 FROM sys.columns WHERE [name] = N'MinDuration'
           AND [object_id] = OBJECT_ID(N'Category'))
BEGIN
    sp_RENAME 'Category.MinDuration', 'SingleDuration' , 'COLUMN'
END

GO

But getting error Incorrect syntax near sp_RENAME. Expecting CONVERSATION, DIALOG, DISTRIBUTED or TRANSACTION

How can I rename my column if it exists in the table?

Answer 1

Try putting exec first:

IF EXISTS(SELECT 1 FROM sys.columns WHERE [name] = N'MinDuration'
           AND [object_id] = OBJECT_ID(N'Category'))
BEGIN
    EXEC sp_RENAME 'Category.MinDuration', 'SingleDuration' , 'COLUMN'
END;