sp_validname (Transact-SQL)

Applies to: SQL Server Azure SQL Database

Checks for valid SQL Server 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 = ] N'name'
    [ , [ @raise_error = ] raise_error ]
[ ; ]

Arguments

[ @name = ] N'name'

The name of the identifiers for which to check validity. @name is sysname, with no default. @name can't be NULL, can't be an empty string, and can't contain a binary-zero character.

[ @raise_error = ] raise_error

Specifies whether to raise an error. @raise_error is bit, with a default of 1, which means that errors are displayed. 0 causes no error messages to appear.

Return code values

0 (success) or 1 (failure).

Permissions

Requires membership in the public role.

Related content

• 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)