Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Transact-SQL Naming Issues

When you analyze the Transact-SQL code in your database project, one or more warnings might be categorized as naming issues. You should address naming issues to avoid the following situations:

  • The name that you specified for an object might conflict with the name of a system object.

  • The name that you specified will always need to be enclosed in escape characters (in SQL Server, '[' and ']').

  • The name that you specified might confuse others who try to read and understand your code.

  • The code might break if you run it with future releases of SQL Server.

In general, you might suppress a naming issue if other applications that you cannot change depend on the current name.

Analyzing Database Code to Improve Code Quality

Describes how you can find common design, performance, and naming issues in your Transact-SQL code.

Transact-SQL Design Issues

Contains links to the different types of design issues that you might find when you analyze your database code.

Transact-SQL Performance Issues

Contains links to the different types of performance issues that you might find when you analyze your database code.

Walkthrough: Analyze Transact-SQL Code for an Existing Database

Describes how you can analyze the AdventureWorks2008 sample database to identify coding issues.

Create and Register Additional Rules for Analyzing Database Code

Describes how you can create your own rules for analyzing database code to look for issues that are not found by the built-in rules.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft