SET QUOTED_IDENTIFIER

Determine if we can/can't create and use objects that have reserved keyword names.

SET QUOTED_IDENTIFIER OFF

GO

CREATE TABLE "select" ("identity" INT IDENTITY NOT NULL, "order" INT NOT NULL);

GO

--> will be failed.

SET QUOTED_IDENTIFIER ON;

GO

CREATE TABLE "select" ("identity" INT IDENTITY NOT NULL, "order" INT NOT NULL);

GO

--> will be succeeded. 

Notes:

Reserved keyword should be delimited by double quotation

Default value of QUOTED_IDENTIFIER = ON.