DF014: String literals as column aliases are deprecated.

Last modified: May 28, 2025

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

Category

DEPRECATED

Message

String literals as column aliases are deprecated.

Description

The ‘String literals as column aliases’ feature is not supported in the latest versions of SQL Server.

Noncompliant code example

SELECT CustomerId AS 'id' FROM dbo.Customers

Compliant solution

SELECT CustomerId AS [id] FROM dbo.Customers