A bug that's a bit tough to find. The
Rename Alias / Variable (F2) functionality does not work if there is a function in the select list and it's with a proc.
For example:
CREATE PROCEDURE dbo.MyProc
AS
BEGIN
SELECT
CommonModule.MyFunction(),
_MyT.MyColumn
FROM
MyTable _MyT
END
You won't be able to Rename _MyT unless you comment out the "MyFunction()" line or the "CREATE PROCEDURE" line.
For example:
CREATE PROCEDURE dbo.MyProc AS BEGIN SELECT CommonModule.MyFunction(), _MyT.MyColumn FROM MyTable _MyT ENDYou won't be able to Rename _MyT unless you comment out the "MyFunction()" line or the "CREATE PROCEDURE" line.