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.component: "system-stored-procedures" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" 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 caps.latest.revision: 32 author: edmacauley ms.author: edmaca manager: craigg monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"
[!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
sp_validname [@name =] 'name'
[, [@raise_error =] raise_error]
[ @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.
0 (success) or 1 (failure)
Requires membership in the public role.
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)