DF059: The assignment operator is used to specify a column alias.

Last modified: May 28, 2025

The topic describes the DF059 T-SQL code analysis rule.

Message

The assignment operator is used to specify a column alias.

According to the ANSI SQL standard, it is recommended to use the AS keyword to specify a column alias.

SELECT CustomerName = c.AccountNumber
FROM sales.Customer c
GO

SELECT c.AccountNumber AS CustomerName
FROM sales.Customer c
GO

Was this page helpful?

Yes

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

If you consider employing this tool for your business, request a demo to see it in action.