Reserved Keywords As Columns In SQL Server

In this post, we’re going to talk about using reserved keywords as column names. This is very similar to the previous “IMPALA – Reserved Keywords As Columns” article, but we will see how it can be implemented in SQL Server this time. It is not best practice to use the reserved keywords for tables and columns, as mentioned in the previous article. Yet one must know how to execute it in the case of condition demands.

In Impala, an error is returned when choosing the columns that are currently reserved keywords in Impala. This is because the tables were built in Hive with the keywords reserved in Impala. We have to use the “`” (escape) symbol for these columns. Similarly, in SQL Server, we would use the name of the column in the “[” and “]” (square brackets a.k.a. box brackets).

Let’s check it out.

USE dbTest

CREATE TABLE ReservedWords([Select] INT, [Update] INT,[Delete] INT, [Insert] INT);
INSERT INTO ReservedWords VALUES (170,20,3,60)
INSERT INTO ReservedWords VALUES (120,15,5,70)
INSERT INTO ReservedWords VALUES (110,17,2,80)
INSERT INTO ReservedWords VALUES (140,12,1,90)

SELECT * FROM ReservedWords
OR you can use-
SELECT [select], [insert], [update], [delete] FROM ReservedWords


The same is applicable to the table names. Look at the below example.

CREATE TABLE [select] ([int] INT);

INSERT INTO [select] VALUES (10),(20),(30)

SELECT [int] FROM [select]

reserved keyword in tablename

Hope you find this article helpful.


  1. Really it is very good technique, while creating table no need to give more lines to insert values.
    In one line itself we can insert the values, if we use box brackets at column names.
    Thanks to SHAFI, it is very use full blog to learners as well as seniors who are working on SQL


    1. I spend a lot of time writing blog posts and frequently forget to express gratitude to my readers and followers. Your feedback is really valuable to me. Thanks a lot.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s