Articles → SQL SERVER → Use Keywords As Identifiers In SQL Server

Use Keywords As Identifiers In SQL Server

This article describes using keywords as an identifier in the SQL Server.

Software Requirement

Before reading this article, ensure that SQL Server Management Studio is installed on your machine.

Scenario

We will create a database named database using the create database command.

Error When Using Keyword As An Identifier

Here, we will execute 3 cases to create the database.

Case	Command	Result On Execution
Case 1	create database database	Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'database'.
Case 2	create database 'database'	Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'database'.
Case 3	create database "database"	Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'database'.

"Set Quoted_Identifier On"

In the previous section, we explored three different ways of using the keyword as an identifier. Among them, the first two methods are not valid in SQL Server, but the third method is applicable.

Before using that execute the following command: -

set quoted_identifier on

Output

Picture showing how the keywords can be used as identifier in SQL server

Posted By -	Karan Gupta

Posted On -	Tuesday, March 12, 2013

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250