Export (0) Print
Expand All
Expand Minimize

sp_validname (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

Topic link icon 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.

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

Community Additions

ADD
Show:
© 2015 Microsoft