sp-validname-transact-sql.md

title	sp_validname (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_validname sp_validname_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_validname
ms.assetid	d51c53c2-1332-407f-b725-4983f2e710eb
author	VanMSFT
ms.author	vanto
manager	craigg
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sp_validname (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Checks for valid [!INCLUDEssNoVersion] identifier names. All nonbinary and nonzero data, including Unicode data that can be stored by using the nchar, nvarchar, or ntext data types, are accepted as valid characters for identifier names.

Transact-SQL Syntax Conventions

Syntax

  
sp_validname [@name =] 'name'   
     [, [@raise_error =] raise_error]  

Arguments

[ @name = ] 'name' Is the name of the identifiers for which to check validity. name is sysname, with no default. name cannot be NULL, cannot be an empty string, and cannot contain a binary-zero character.

[ @raise_error = ] raise_error Specifies whether to raise an error. raise_error is bit, with a default of 1. This means that errors will appear. 0 causes no error messages to appear.

Return Code Values

0 (success) or 1 (failure)

Permissions

Requires membership in the public role.

See Also

Database Engine Stored Procedures (Transact-SQL)
Data Types (Transact-SQL)
NCHAR (Transact-SQL)
nchar and nvarchar (Transact-SQL)
ntext, text, and image (Transact-SQL)
System Stored Procedures (Transact-SQL)