DF062: Column alias is specified without the AS keyword.
Last modified: June 12, 2025
The topic describes the DF062 T-SQL code analysis rule.
Category
DEPRECATED
Message
Column alias is specified without the AS
keyword.
Description
Consider using the AS
keyword to specify a column alias or add a possibly missing delimiter between column names.
Additional information
Specifying aliases with the AS
keyword enhances the readability of SQL queries by providing descriptive names for columns or expressions in the result set. Additionally, adding delimiters between column names helps prevent potential syntax errors, especially in cases where column names contain spaces or special characters. By adopting these practices, you improve the clarity and maintainability of your SQL code, making it easier to understand and modify.
Noncompliant code example
SELECT c.object_id column_id
FROM sys.columns c
Compliant solution
SELECT c.object_id AS column_id
FROM sys.columns c
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.