--- title: "Reserved Keywords (Transact-SQL)" description: "Reserved Keywords (Transact-SQL)" author: rwestMSFT ms.author: randolphwest ms.reviewer: "" ms.date: "03/14/2017" ms.prod: sql ms.prod_service: "database-engine, sql-database, synapse-analytics, pdw" ms.technology: t-sql ms.topic: reference ms.custom: "" helpviewer_keywords: - "ODBC function calls" - "keywords [SQL Server], reserved" - "reserved words [SQL Server]" - "keywords [SQL Server]" dev_langs: - "TSQL" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current" --- # Reserved Keywords (Transact-SQL) [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)] [!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] uses reserved keywords for defining, manipulating, and accessing databases. Reserved keywords are part of the grammar of the [!INCLUDE[tsql](../../includes/tsql-md.md)] language that is used by [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to parse and understand [!INCLUDE[tsql](../../includes/tsql-md.md)] statements and batches. Although it is syntactically possible to use [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] reserved keywords as identifiers and object names in [!INCLUDE[tsql](../../includes/tsql-md.md)] scripts, you can do this only by using delimited identifiers. The following table lists [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] and [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)] reserved keywords. :::row::: :::column::: ADD :::column-end::: :::column::: EXTERNAL :::column-end::: :::column::: PROCEDURE :::column-end::: :::row-end::: :::row::: :::column::: ALL :::column-end::: :::column::: FETCH :::column-end::: :::column::: PUBLIC :::column-end::: :::row-end::: :::row::: :::column::: ALTER :::column-end::: :::column::: FILE :::column-end::: :::column::: RAISERROR :::column-end::: :::row-end::: :::row::: :::column::: AND :::column-end::: :::column::: FILLFACTOR :::column-end::: :::column::: READ :::column-end::: :::row-end::: :::row::: :::column::: ANY :::column-end::: :::column::: FOR :::column-end::: :::column::: READTEXT :::column-end::: :::row-end::: :::row::: :::column::: AS :::column-end::: :::column::: FOREIGN :::column-end::: :::column::: RECONFIGURE :::column-end::: :::row-end::: :::row::: :::column::: ASC :::column-end::: :::column::: FREETEXT :::column-end::: :::column::: REFERENCES :::column-end::: :::row-end::: :::row::: :::column::: AUTHORIZATION :::column-end::: :::column::: FREETEXTTABLE :::column-end::: :::column::: REPLICATION :::column-end::: :::row-end::: :::row::: :::column::: BACKUP :::column-end::: :::column::: FROM :::column-end::: :::column::: RESTORE :::column-end::: :::row-end::: :::row::: :::column::: BEGIN :::column-end::: :::column::: FULL :::column-end::: :::column::: RESTRICT :::column-end::: :::row-end::: :::row::: :::column::: BETWEEN :::column-end::: :::column::: FUNCTION :::column-end::: :::column::: RETURN :::column-end::: :::row-end::: :::row::: :::column::: BREAK :::column-end::: :::column::: GOTO :::column-end::: :::column::: REVERT :::column-end::: :::row-end::: :::row::: :::column::: BROWSE :::column-end::: :::column::: GRANT :::column-end::: :::column::: REVOKE :::column-end::: :::row-end::: :::row::: :::column::: BULK :::column-end::: :::column::: GROUP :::column-end::: :::column::: RIGHT :::column-end::: :::row-end::: :::row::: :::column::: BY :::column-end::: :::column::: HAVING :::column-end::: :::column::: ROLLBACK :::column-end::: :::row-end::: :::row::: :::column::: CASCADE :::column-end::: :::column::: HOLDLOCK :::column-end::: :::column::: ROWCOUNT :::column-end::: :::row-end::: :::row::: :::column::: CASE :::column-end::: :::column::: IDENTITY :::column-end::: :::column::: ROWGUIDCOL :::column-end::: :::row-end::: :::row::: :::column::: CHECK :::column-end::: :::column::: IDENTITY_INSERT :::column-end::: :::column::: RULE :::column-end::: :::row-end::: :::row::: :::column::: CHECKPOINT :::column-end::: :::column::: IDENTITYCOL :::column-end::: :::column::: SAVE :::column-end::: :::row-end::: :::row::: :::column::: CLOSE :::column-end::: :::column::: IF :::column-end::: :::column::: SCHEMA :::column-end::: :::row-end::: :::row::: :::column::: CLUSTERED :::column-end::: :::column::: IN :::column-end::: :::column::: SECURITYAUDIT :::column-end::: :::row-end::: :::row::: :::column::: COALESCE :::column-end::: :::column::: INDEX :::column-end::: :::column::: SELECT :::column-end::: :::row-end::: :::row::: :::column::: COLLATE :::column-end::: :::column::: INNER :::column-end::: :::column::: SEMANTICKEYPHRASETABLE :::column-end::: :::row-end::: :::row::: :::column::: COLUMN :::column-end::: :::column::: INSERT :::column-end::: :::column::: SEMANTICSIMILARITYDETAILSTABLE :::column-end::: :::row-end::: :::row::: :::column::: COMMIT :::column-end::: :::column::: INTERSECT :::column-end::: :::column::: SEMANTICSIMILARITYTABLE :::column-end::: :::row-end::: :::row::: :::column::: COMPUTE :::column-end::: :::column::: INTO :::column-end::: :::column::: SESSION_USER :::column-end::: :::row-end::: :::row::: :::column::: CONSTRAINT :::column-end::: :::column::: IS :::column-end::: :::column::: SET :::column-end::: :::row-end::: :::row::: :::column::: CONTAINS :::column-end::: :::column::: JOIN :::column-end::: :::column::: SETUSER :::column-end::: :::row-end::: :::row::: :::column::: CONTAINSTABLE :::column-end::: :::column::: KEY :::column-end::: :::column::: SHUTDOWN :::column-end::: :::row-end::: :::row::: :::column::: CONTINUE :::column-end::: :::column::: KILL :::column-end::: :::column::: SOME :::column-end::: :::row-end::: :::row::: :::column::: CONVERT :::column-end::: :::column::: LEFT :::column-end::: :::column::: STATISTICS :::column-end::: :::row-end::: :::row::: :::column::: CREATE :::column-end::: :::column::: LIKE :::column-end::: :::column::: SYSTEM_USER :::column-end::: :::row-end::: :::row::: :::column::: CROSS :::column-end::: :::column::: LINENO :::column-end::: :::column::: TABLE :::column-end::: :::row-end::: :::row::: :::column::: CURRENT :::column-end::: :::column::: LOAD :::column-end::: :::column::: TABLESAMPLE :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_DATE :::column-end::: :::column::: MERGE :::column-end::: :::column::: TEXTSIZE :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_TIME :::column-end::: :::column::: NATIONAL :::column-end::: :::column::: THEN :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_TIMESTAMP :::column-end::: :::column::: NOCHECK :::column-end::: :::column::: TO :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_USER :::column-end::: :::column::: NONCLUSTERED :::column-end::: :::column::: TOP :::column-end::: :::row-end::: :::row::: :::column::: CURSOR :::column-end::: :::column::: NOT :::column-end::: :::column::: TRAN :::column-end::: :::row-end::: :::row::: :::column::: DATABASE :::column-end::: :::column::: NULL :::column-end::: :::column::: TRANSACTION :::column-end::: :::row-end::: :::row::: :::column::: DBCC :::column-end::: :::column::: NULLIF :::column-end::: :::column::: TRIGGER :::column-end::: :::row-end::: :::row::: :::column::: DEALLOCATE :::column-end::: :::column::: OF :::column-end::: :::column::: TRUNCATE :::column-end::: :::row-end::: :::row::: :::column::: DECLARE :::column-end::: :::column::: OFF :::column-end::: :::column::: TRY_CONVERT :::column-end::: :::row-end::: :::row::: :::column::: DEFAULT :::column-end::: :::column::: OFFSETS :::column-end::: :::column::: TSEQUAL :::column-end::: :::row-end::: :::row::: :::column::: DELETE :::column-end::: :::column::: ON :::column-end::: :::column::: UNION :::column-end::: :::row-end::: :::row::: :::column::: DENY :::column-end::: :::column::: OPEN :::column-end::: :::column::: UNIQUE :::column-end::: :::row-end::: :::row::: :::column::: DESC :::column-end::: :::column::: OPENDATASOURCE :::column-end::: :::column::: UNPIVOT :::column-end::: :::row-end::: :::row::: :::column::: DISK :::column-end::: :::column::: OPENQUERY :::column-end::: :::column::: UPDATE :::column-end::: :::row-end::: :::row::: :::column::: DISTINCT :::column-end::: :::column::: OPENROWSET :::column-end::: :::column::: UPDATETEXT :::column-end::: :::row-end::: :::row::: :::column::: DISTRIBUTED :::column-end::: :::column::: OPENXML :::column-end::: :::column::: USE :::column-end::: :::row-end::: :::row::: :::column::: DOUBLE :::column-end::: :::column::: OPTION :::column-end::: :::column::: USER :::column-end::: :::row-end::: :::row::: :::column::: DROP :::column-end::: :::column::: OR :::column-end::: :::column::: VALUES :::column-end::: :::row-end::: :::row::: :::column::: DUMP :::column-end::: :::column::: ORDER :::column-end::: :::column::: VARYING :::column-end::: :::row-end::: :::row::: :::column::: ELSE :::column-end::: :::column::: OUTER :::column-end::: :::column::: VIEW :::column-end::: :::row-end::: :::row::: :::column::: END :::column-end::: :::column::: OVER :::column-end::: :::column::: WAITFOR :::column-end::: :::row-end::: :::row::: :::column::: ERRLVL :::column-end::: :::column::: PERCENT :::column-end::: :::column::: WHEN :::column-end::: :::row-end::: :::row::: :::column::: ESCAPE :::column-end::: :::column::: PIVOT :::column-end::: :::column::: WHERE :::column-end::: :::row-end::: :::row::: :::column::: EXCEPT :::column-end::: :::column::: PLAN :::column-end::: :::column::: WHILE :::column-end::: :::row-end::: :::row::: :::column::: EXEC :::column-end::: :::column::: PRECISION :::column-end::: :::column::: WITH :::column-end::: :::row-end::: :::row::: :::column::: EXECUTE :::column-end::: :::column::: PRIMARY :::column-end::: :::column::: WITHIN GROUP :::column-end::: :::row-end::: :::row::: :::column::: EXISTS :::column-end::: :::column::: PRINT :::column-end::: :::column::: WRITETEXT :::column-end::: :::row-end::: :::row::: :::column::: EXIT :::column-end::: :::column::: PROC :::column-end::: :::column::: :::column-end::: :::row-end::: The following table lists reserved keywords that are exclusive to **[!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)]**. :::row::: :::column::: **LABEL** :::column-end::: :::row-end::: Additionally, the ISO standard defines a list of reserved keywords. Avoid using ISO reserved keywords for object names and identifiers. The ODBC reserved keyword list, shown in the following table, is the same as the ISO reserved keyword list. > [!NOTE] > The ISO standards reserved keywords list sometimes can be more restrictive than [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] and at other times less restrictive. For example, the ISO reserved keywords list contains **INT**. [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] does not have to distinguish this as a reserved keyword. [!INCLUDE[tsql](../../includes/tsql-md.md)] reserved keywords can be used as identifiers or names of databases or database objects, such as tables, columns, views, and so on. Use either quoted identifiers or delimited identifiers. Using reserved keywords as the names of variables and stored procedure parameters is not restricted. ## ODBC Reserved Keywords The following words are reserved for use in ODBC function calls. These words do not constrain the minimum SQL grammar; however, to ensure compatibility with drivers that support the core SQL grammar, applications should avoid using these keywords. This is the current list of ODBC reserved keywords. :::row::: :::column::: **ABSOLUTE** :::column-end::: :::column::: **EXEC** :::column-end::: :::column::: **OVERLAPS** :::column-end::: :::row-end::: :::row::: :::column::: **ACTION** :::column-end::: :::column::: **EXECUTE** :::column-end::: :::column::: **PAD** :::column-end::: :::row-end::: :::row::: :::column::: **ADA** :::column-end::: :::column::: **EXISTS** :::column-end::: :::column::: **PARTIAL** :::column-end::: :::row-end::: :::row::: :::column::: **ADD** :::column-end::: :::column::: **EXTERNAL** :::column-end::: :::column::: **PASCAL** :::column-end::: :::row-end::: :::row::: :::column::: **ALL** :::column-end::: :::column::: **EXTRACT** :::column-end::: :::column::: **POSITION** :::column-end::: :::row-end::: :::row::: :::column::: **ALLOCATE** :::column-end::: :::column::: **FALSE** :::column-end::: :::column::: **PRECISION** :::column-end::: :::row-end::: :::row::: :::column::: **ALTER** :::column-end::: :::column::: **FETCH** :::column-end::: :::column::: **PREPARE** :::column-end::: :::row-end::: :::row::: :::column::: **AND** :::column-end::: :::column::: **FIRST** :::column-end::: :::column::: **PRESERVE** :::column-end::: :::row-end::: :::row::: :::column::: **ANY** :::column-end::: :::column::: **FLOAT** :::column-end::: :::column::: **PRIMARY** :::column-end::: :::row-end::: :::row::: :::column::: **ARE** :::column-end::: :::column::: **FOR** :::column-end::: :::column::: **PRIOR** :::column-end::: :::row-end::: :::row::: :::column::: **AS** :::column-end::: :::column::: **FOREIGN** :::column-end::: :::column::: **PRIVILEGES** :::column-end::: :::row-end::: :::row::: :::column::: **ASC** :::column-end::: :::column::: **FORTRAN** :::column-end::: :::column::: **PROCEDURE** :::column-end::: :::row-end::: :::row::: :::column::: **ASSERTION** :::column-end::: :::column::: **FOUND** :::column-end::: :::column::: **PUBLIC** :::column-end::: :::row-end::: :::row::: :::column::: **AT** :::column-end::: :::column::: **FROM** :::column-end::: :::column::: **READ** :::column-end::: :::row-end::: :::row::: :::column::: **AUTHORIZATION** :::column-end::: :::column::: **FULL** :::column-end::: :::column::: **REAL** :::column-end::: :::row-end::: :::row::: :::column::: **AVG** :::column-end::: :::column::: **GET** :::column-end::: :::column::: **REFERENCES** :::column-end::: :::row-end::: :::row::: :::column::: **BEGIN** :::column-end::: :::column::: **GLOBAL** :::column-end::: :::column::: **RELATIVE** :::column-end::: :::row-end::: :::row::: :::column::: **BETWEEN** :::column-end::: :::column::: **GO** :::column-end::: :::column::: **RESTRICT** :::column-end::: :::row-end::: :::row::: :::column::: **BIT** :::column-end::: :::column::: **GOTO** :::column-end::: :::column::: **REVOKE** :::column-end::: :::row-end::: :::row::: :::column::: **BIT_LENGTH** :::column-end::: :::column::: **GRANT** :::column-end::: :::column::: **RIGHT** :::column-end::: :::row-end::: :::row::: :::column::: **BOTH** :::column-end::: :::column::: **GROUP** :::column-end::: :::column::: **ROLLBACK** :::column-end::: :::row-end::: :::row::: :::column::: **BY** :::column-end::: :::column::: **HAVING** :::column-end::: :::column::: **ROWS** :::column-end::: :::row-end::: :::row::: :::column::: **CASCADE** :::column-end::: :::column::: **HOUR** :::column-end::: :::column::: **SCHEMA** :::column-end::: :::row-end::: :::row::: :::column::: **CASCADED** :::column-end::: :::column::: **IDENTITY** :::column-end::: :::column::: **SCROLL** :::column-end::: :::row-end::: :::row::: :::column::: **CASE** :::column-end::: :::column::: **IMMEDIATE** :::column-end::: :::column::: **SECOND** :::column-end::: :::row-end::: :::row::: :::column::: **CAST** :::column-end::: :::column::: **IN** :::column-end::: :::column::: **SECTION** :::column-end::: :::row-end::: :::row::: :::column::: **CATALOG** :::column-end::: :::column::: **INCLUDE** :::column-end::: :::column::: **SELECT** :::column-end::: :::row-end::: :::row::: :::column::: **CHAR** :::column-end::: :::column::: **INDEX** :::column-end::: :::column::: **SESSION** :::column-end::: :::row-end::: :::row::: :::column::: **CHAR_LENGTH** :::column-end::: :::column::: **INDICATOR** :::column-end::: :::column::: **SESSION_USER** :::column-end::: :::row-end::: :::row::: :::column::: **CHARACTER** :::column-end::: :::column::: **INITIALLY** :::column-end::: :::column::: **SET** :::column-end::: :::row-end::: :::row::: :::column::: **CHARACTER_LENGTH** :::column-end::: :::column::: **INNER** :::column-end::: :::column::: **SIZE** :::column-end::: :::row-end::: :::row::: :::column::: **CHECK** :::column-end::: :::column::: **INPUT** :::column-end::: :::column::: **SMALLINT** :::column-end::: :::row-end::: :::row::: :::column::: **CLOSE** :::column-end::: :::column::: **INSENSITIVE** :::column-end::: :::column::: **SOME** :::column-end::: :::row-end::: :::row::: :::column::: **COALESCE** :::column-end::: :::column::: **INSERT** :::column-end::: :::column::: **SPACE** :::column-end::: :::row-end::: :::row::: :::column::: **COLLATE** :::column-end::: :::column::: **INT** :::column-end::: :::column::: **SQL** :::column-end::: :::row-end::: :::row::: :::column::: **COLLATION** :::column-end::: :::column::: **INTEGER** :::column-end::: :::column::: **SQLCA** :::column-end::: :::row-end::: :::row::: :::column::: **COLUMN** :::column-end::: :::column::: **INTERSECT** :::column-end::: :::column::: **SQLCODE** :::column-end::: :::row-end::: :::row::: :::column::: **COMMIT** :::column-end::: :::column::: **INTERVAL** :::column-end::: :::column::: **SQLERROR** :::column-end::: :::row-end::: :::row::: :::column::: **CONNECT** :::column-end::: :::column::: **INTO** :::column-end::: :::column::: **SQLSTATE** :::column-end::: :::row-end::: :::row::: :::column::: **CONNECTION** :::column-end::: :::column::: **IS** :::column-end::: :::column::: **SQLWARNING** :::column-end::: :::row-end::: :::row::: :::column::: **CONSTRAINT** :::column-end::: :::column::: **ISOLATION** :::column-end::: :::column::: **SUBSTRING** :::column-end::: :::row-end::: :::row::: :::column::: **CONSTRAINTS** :::column-end::: :::column::: **JOIN** :::column-end::: :::column::: **SUM** :::column-end::: :::row-end::: :::row::: :::column::: **CONTINUE** :::column-end::: :::column::: **KEY** :::column-end::: :::column::: **SYSTEM_USER** :::column-end::: :::row-end::: :::row::: :::column::: **CONVERT** :::column-end::: :::column::: **LANGUAGE** :::column-end::: :::column::: **TABLE** :::column-end::: :::row-end::: :::row::: :::column::: **CORRESPONDING** :::column-end::: :::column::: **LAST** :::column-end::: :::column::: **TEMPORARY** :::column-end::: :::row-end::: :::row::: :::column::: **COUNT** :::column-end::: :::column::: **LEADING** :::column-end::: :::column::: **THEN** :::column-end::: :::row-end::: :::row::: :::column::: **CREATE** :::column-end::: :::column::: **LEFT** :::column-end::: :::column::: **TIME** :::column-end::: :::row-end::: :::row::: :::column::: **CROSS** :::column-end::: :::column::: **LEVEL** :::column-end::: :::column::: **TIMESTAMP** :::column-end::: :::row-end::: :::row::: :::column::: **CURRENT** :::column-end::: :::column::: **LIKE** :::column-end::: :::column::: **TIMEZONE_HOUR** :::column-end::: :::row-end::: :::row::: :::column::: **CURRENT_DATE** :::column-end::: :::column::: **LOCAL** :::column-end::: :::column::: **TIMEZONE_MINUTE** :::column-end::: :::row-end::: :::row::: :::column::: **CURRENT_TIME** :::column-end::: :::column::: **LOWER** :::column-end::: :::column::: **TO** :::column-end::: :::row-end::: :::row::: :::column::: **CURRENT_TIMESTAMP** :::column-end::: :::column::: **MATCH** :::column-end::: :::column::: **TRAILING** :::column-end::: :::row-end::: :::row::: :::column::: **CURRENT_USER** :::column-end::: :::column::: **MAX** :::column-end::: :::column::: **TRANSACTION** :::column-end::: :::row-end::: :::row::: :::column::: **CURSOR** :::column-end::: :::column::: **MIN** :::column-end::: :::column::: **TRANSLATE** :::column-end::: :::row-end::: :::row::: :::column::: **DATE** :::column-end::: :::column::: **MINUTE** :::column-end::: :::column::: **TRANSLATION** :::column-end::: :::row-end::: :::row::: :::column::: **DAY** :::column-end::: :::column::: **MODULE** :::column-end::: :::column::: **TRIM** :::column-end::: :::row-end::: :::row::: :::column::: **DEALLOCATE** :::column-end::: :::column::: **MONTH** :::column-end::: :::column::: **TRUE** :::column-end::: :::row-end::: :::row::: :::column::: **DEC** :::column-end::: :::column::: **NAMES** :::column-end::: :::column::: **UNION** :::column-end::: :::row-end::: :::row::: :::column::: **DECIMAL** :::column-end::: :::column::: **NATIONAL** :::column-end::: :::column::: **UNIQUE** :::column-end::: :::row-end::: :::row::: :::column::: **DECLARE** :::column-end::: :::column::: **NATURAL** :::column-end::: :::column::: **UNKNOWN** :::column-end::: :::row-end::: :::row::: :::column::: **DEFAULT** :::column-end::: :::column::: **NCHAR** :::column-end::: :::column::: **UPDATE** :::column-end::: :::row-end::: :::row::: :::column::: **DEFERRABLE** :::column-end::: :::column::: **NEXT** :::column-end::: :::column::: **UPPER** :::column-end::: :::row-end::: :::row::: :::column::: **DEFERRED** :::column-end::: :::column::: **NO** :::column-end::: :::column::: **USAGE** :::column-end::: :::row-end::: :::row::: :::column::: **DELETE** :::column-end::: :::column::: **NONE** :::column-end::: :::column::: **USER** :::column-end::: :::row-end::: :::row::: :::column::: **DESC** :::column-end::: :::column::: **NOT** :::column-end::: :::column::: **USING** :::column-end::: :::row-end::: :::row::: :::column::: **DESCRIBE** :::column-end::: :::column::: **NULL** :::column-end::: :::column::: **VALUE** :::column-end::: :::row-end::: :::row::: :::column::: **DESCRIPTOR** :::column-end::: :::column::: **NULLIF** :::column-end::: :::column::: **VALUES** :::column-end::: :::row-end::: :::row::: :::column::: **DIAGNOSTICS** :::column-end::: :::column::: **NUMERIC** :::column-end::: :::column::: **VARCHAR** :::column-end::: :::row-end::: :::row::: :::column::: **DISCONNECT** :::column-end::: :::column::: **OCTET_LENGTH** :::column-end::: :::column::: **VARYING** :::column-end::: :::row-end::: :::row::: :::column::: **DISTINCT** :::column-end::: :::column::: **OF** :::column-end::: :::column::: **VIEW** :::column-end::: :::row-end::: :::row::: :::column::: **DOMAIN** :::column-end::: :::column::: **ON** :::column-end::: :::column::: **WHEN** :::column-end::: :::row-end::: :::row::: :::column::: **DOUBLE** :::column-end::: :::column::: **ONLY** :::column-end::: :::column::: **WHENEVER** :::column-end::: :::row-end::: :::row::: :::column::: **DROP** :::column-end::: :::column::: **OPEN** :::column-end::: :::column::: **WHERE** :::column-end::: :::row-end::: :::row::: :::column::: **ELSE** :::column-end::: :::column::: **OPTION** :::column-end::: :::column::: **WITH** :::column-end::: :::row-end::: :::row::: :::column::: **END** :::column-end::: :::column::: **OR** :::column-end::: :::column::: **WORK** :::column-end::: :::row-end::: :::row::: :::column::: **END-EXEC** :::column-end::: :::column::: **ORDER** :::column-end::: :::column::: **WRITE** :::column-end::: :::row-end::: :::row::: :::column::: **ESCAPE** :::column-end::: :::column::: **OUTER** :::column-end::: :::column::: **YEAR** :::column-end::: :::row-end::: :::row::: :::column::: **EXCEPT** :::column-end::: :::column::: **OUTPUT** :::column-end::: :::column::: **ZONE** :::column-end::: :::row-end::: :::row::: :::column::: **EXCEPTION** :::column-end::: :::column::: :::column-end::: :::column::: :::column-end::: :::row-end::: ## Future Keywords The following keywords could be reserved in future releases of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] as new features are implemented. Consider avoiding the use of these words as identifiers. :::row::: :::column::: ABSOLUTE :::column-end::: :::column::: HOST :::column-end::: :::column::: RELATIVE :::column-end::: :::row-end::: :::row::: :::column::: ACTION :::column-end::: :::column::: HOUR :::column-end::: :::column::: RELEASE :::column-end::: :::row-end::: :::row::: :::column::: ADMIN :::column-end::: :::column::: IGNORE :::column-end::: :::column::: RESULT :::column-end::: :::row-end::: :::row::: :::column::: AFTER :::column-end::: :::column::: IMMEDIATE :::column-end::: :::column::: RETURNS :::column-end::: :::row-end::: :::row::: :::column::: AGGREGATE :::column-end::: :::column::: INDICATOR :::column-end::: :::column::: ROLE :::column-end::: :::row-end::: :::row::: :::column::: ALIAS :::column-end::: :::column::: INITIALIZE :::column-end::: :::column::: ROLLUP :::column-end::: :::row-end::: :::row::: :::column::: ALLOCATE :::column-end::: :::column::: INITIALLY :::column-end::: :::column::: ROUTINE :::column-end::: :::row-end::: :::row::: :::column::: ARE :::column-end::: :::column::: INOUT :::column-end::: :::column::: ROW :::column-end::: :::row-end::: :::row::: :::column::: ARRAY :::column-end::: :::column::: INPUT :::column-end::: :::column::: ROWS :::column-end::: :::row-end::: :::row::: :::column::: ASENSITIVE :::column-end::: :::column::: INT :::column-end::: :::column::: SAVEPOINT :::column-end::: :::row-end::: :::row::: :::column::: ASSERTION :::column-end::: :::column::: INTEGER :::column-end::: :::column::: SCROLL :::column-end::: :::row-end::: :::row::: :::column::: ASYMMETRIC :::column-end::: :::column::: INTERSECTION :::column-end::: :::column::: SCOPE :::column-end::: :::row-end::: :::row::: :::column::: AT :::column-end::: :::column::: INTERVAL :::column-end::: :::column::: SEARCH :::column-end::: :::row-end::: :::row::: :::column::: ATOMIC :::column-end::: :::column::: ISOLATION :::column-end::: :::column::: SECOND :::column-end::: :::row-end::: :::row::: :::column::: BEFORE :::column-end::: :::column::: ITERATE :::column-end::: :::column::: SECTION :::column-end::: :::row-end::: :::row::: :::column::: BINARY :::column-end::: :::column::: LANGUAGE :::column-end::: :::column::: SENSITIVE :::column-end::: :::row-end::: :::row::: :::column::: BIT :::column-end::: :::column::: LARGE :::column-end::: :::column::: SEQUENCE :::column-end::: :::row-end::: :::row::: :::column::: BLOB :::column-end::: :::column::: LAST :::column-end::: :::column::: SESSION :::column-end::: :::row-end::: :::row::: :::column::: BOOLEAN :::column-end::: :::column::: LATERAL :::column-end::: :::column::: SETS :::column-end::: :::row-end::: :::row::: :::column::: BOTH :::column-end::: :::column::: LEADING :::column-end::: :::column::: SIMILAR :::column-end::: :::row-end::: :::row::: :::column::: BREADTH :::column-end::: :::column::: LESS :::column-end::: :::column::: SIZE :::column-end::: :::row-end::: :::row::: :::column::: CALL :::column-end::: :::column::: LEVEL :::column-end::: :::column::: SMALLINT :::column-end::: :::row-end::: :::row::: :::column::: CALLED :::column-end::: :::column::: LIKE_REGEX :::column-end::: :::column::: SPACE :::column-end::: :::row-end::: :::row::: :::column::: CARDINALITY :::column-end::: :::column::: LIMIT :::column-end::: :::column::: SPECIFIC :::column-end::: :::row-end::: :::row::: :::column::: CASCADED :::column-end::: :::column::: LN :::column-end::: :::column::: SPECIFICTYPE :::column-end::: :::row-end::: :::row::: :::column::: CAST :::column-end::: :::column::: LOCAL :::column-end::: :::column::: SQL :::column-end::: :::row-end::: :::row::: :::column::: CATALOG :::column-end::: :::column::: LOCALTIME :::column-end::: :::column::: SQLEXCEPTION :::column-end::: :::row-end::: :::row::: :::column::: CHAR :::column-end::: :::column::: LOCALTIMESTAMP :::column-end::: :::column::: SQLSTATE :::column-end::: :::row-end::: :::row::: :::column::: CHARACTER :::column-end::: :::column::: LOCATOR :::column-end::: :::column::: SQLWARNING :::column-end::: :::row-end::: :::row::: :::column::: CLASS :::column-end::: :::column::: MAP :::column-end::: :::column::: START :::column-end::: :::row-end::: :::row::: :::column::: CLOB :::column-end::: :::column::: MATCH :::column-end::: :::column::: STATE :::column-end::: :::row-end::: :::row::: :::column::: COLLATION :::column-end::: :::column::: MEMBER :::column-end::: :::column::: STATEMENT :::column-end::: :::row-end::: :::row::: :::column::: COLLECT :::column-end::: :::column::: METHOD :::column-end::: :::column::: STATIC :::column-end::: :::row-end::: :::row::: :::column::: COMPLETION :::column-end::: :::column::: MINUTE :::column-end::: :::column::: STDDEV_POP :::column-end::: :::row-end::: :::row::: :::column::: CONDITION :::column-end::: :::column::: MOD :::column-end::: :::column::: STDDEV_SAMP :::column-end::: :::row-end::: :::row::: :::column::: CONNECT :::column-end::: :::column::: MODIFIES :::column-end::: :::column::: STRUCTURE :::column-end::: :::row-end::: :::row::: :::column::: CONNECTION :::column-end::: :::column::: MODIFY :::column-end::: :::column::: SUBMULTISET :::column-end::: :::row-end::: :::row::: :::column::: CONSTRAINTS :::column-end::: :::column::: MODULE :::column-end::: :::column::: SUBSTRING_REGEX :::column-end::: :::row-end::: :::row::: :::column::: CONSTRUCTOR :::column-end::: :::column::: MONTH :::column-end::: :::column::: SYMMETRIC :::column-end::: :::row-end::: :::row::: :::column::: CORR :::column-end::: :::column::: MULTISET :::column-end::: :::column::: SYSTEM :::column-end::: :::row-end::: :::row::: :::column::: CORRESPONDING :::column-end::: :::column::: NAMES :::column-end::: :::column::: TEMPORARY :::column-end::: :::row-end::: :::row::: :::column::: COVAR_POP :::column-end::: :::column::: NATURAL :::column-end::: :::column::: TERMINATE :::column-end::: :::row-end::: :::row::: :::column::: COVAR_SAMP :::column-end::: :::column::: NCHAR :::column-end::: :::column::: THAN :::column-end::: :::row-end::: :::row::: :::column::: CUBE :::column-end::: :::column::: NCLOB :::column-end::: :::column::: TIME :::column-end::: :::row-end::: :::row::: :::column::: CUME_DIST :::column-end::: :::column::: NEW :::column-end::: :::column::: TIMESTAMP :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_CATALOG :::column-end::: :::column::: NEXT :::column-end::: :::column::: TIMEZONE_HOUR :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_DEFAULT_TRANSFORM_GROUP :::column-end::: :::column::: NO :::column-end::: :::column::: TIMEZONE_MINUTE :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_PATH :::column-end::: :::column::: NONE :::column-end::: :::column::: TRAILING :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_ROLE :::column-end::: :::column::: NORMALIZE :::column-end::: :::column::: TRANSLATE_REGEX :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_SCHEMA :::column-end::: :::column::: NUMERIC :::column-end::: :::column::: TRANSLATION :::column-end::: :::row-end::: :::row::: :::column::: CURRENT_TRANSFORM_GROUP_FOR_TYPE :::column-end::: :::column::: OBJECT :::column-end::: :::column::: TREAT :::column-end::: :::row-end::: :::row::: :::column::: CYCLE :::column-end::: :::column::: OCCURRENCES_REGEX :::column-end::: :::column::: TRUE :::column-end::: :::row-end::: :::row::: :::column::: DATA :::column-end::: :::column::: OLD :::column-end::: :::column::: UESCAPE :::column-end::: :::row-end::: :::row::: :::column::: DATE :::column-end::: :::column::: ONLY :::column-end::: :::column::: UNDER :::column-end::: :::row-end::: :::row::: :::column::: DAY :::column-end::: :::column::: OPERATION :::column-end::: :::column::: UNKNOWN :::column-end::: :::row-end::: :::row::: :::column::: DEC :::column-end::: :::column::: ORDINALITY :::column-end::: :::column::: UNNEST :::column-end::: :::row-end::: :::row::: :::column::: DECIMAL :::column-end::: :::column::: OUT :::column-end::: :::column::: USAGE :::column-end::: :::row-end::: :::row::: :::column::: DEFERRABLE :::column-end::: :::column::: OVERLAY :::column-end::: :::column::: USING :::column-end::: :::row-end::: :::row::: :::column::: DEFERRED :::column-end::: :::column::: OUTPUT :::column-end::: :::column::: VALUE :::column-end::: :::row-end::: :::row::: :::column::: DEPTH :::column-end::: :::column::: PAD :::column-end::: :::column::: VAR_POP :::column-end::: :::row-end::: :::row::: :::column::: DEREF :::column-end::: :::column::: PARAMETER :::column-end::: :::column::: VAR_SAMP :::column-end::: :::row-end::: :::row::: :::column::: DESCRIBE :::column-end::: :::column::: PARAMETERS :::column-end::: :::column::: VARCHAR :::column-end::: :::row-end::: :::row::: :::column::: DESCRIPTOR :::column-end::: :::column::: PARTIAL :::column-end::: :::column::: VARIABLE :::column-end::: :::row-end::: :::row::: :::column::: DESTROY :::column-end::: :::column::: PARTITION :::column-end::: :::column::: WHENEVER :::column-end::: :::row-end::: :::row::: :::column::: DESTRUCTOR :::column-end::: :::column::: PATH :::column-end::: :::column::: WIDTH_BUCKET :::column-end::: :::row-end::: :::row::: :::column::: DETERMINISTIC :::column-end::: :::column::: POSTFIX :::column-end::: :::column::: WITHOUT :::column-end::: :::row-end::: :::row::: :::column::: DICTIONARY :::column-end::: :::column::: PREFIX :::column-end::: :::column::: WINDOW :::column-end::: :::row-end::: :::row::: :::column::: DIAGNOSTICS :::column-end::: :::column::: PREORDER :::column-end::: :::column::: WITHIN :::column-end::: :::row-end::: :::row::: :::column::: DISCONNECT :::column-end::: :::column::: PREPARE :::column-end::: :::column::: WORK :::column-end::: :::row-end::: :::row::: :::column::: DOMAIN :::column-end::: :::column::: PERCENT_RANK :::column-end::: :::column::: WRITE :::column-end::: :::row-end::: :::row::: :::column::: DYNAMIC :::column-end::: :::column::: PERCENTILE_CONT :::column-end::: :::column::: XMLAGG :::column-end::: :::row-end::: :::row::: :::column::: EACH :::column-end::: :::column::: PERCENTILE_DISC :::column-end::: :::column::: XMLATTRIBUTES :::column-end::: :::row-end::: :::row::: :::column::: ELEMENT :::column-end::: :::column::: POSITION_REGEX :::column-end::: :::column::: XMLBINARY :::column-end::: :::row-end::: :::row::: :::column::: END-EXEC :::column-end::: :::column::: PRESERVE :::column-end::: :::column::: XMLCAST :::column-end::: :::row-end::: :::row::: :::column::: EQUALS :::column-end::: :::column::: PRIOR :::column-end::: :::column::: XMLCOMMENT :::column-end::: :::row-end::: :::row::: :::column::: EVERY :::column-end::: :::column::: PRIVILEGES :::column-end::: :::column::: XMLCONCAT :::column-end::: :::row-end::: :::row::: :::column::: EXCEPTION :::column-end::: :::column::: RANGE :::column-end::: :::column::: XMLDOCUMENT :::column-end::: :::row-end::: :::row::: :::column::: FALSE :::column-end::: :::column::: READS :::column-end::: :::column::: XMLELEMENT :::column-end::: :::row-end::: :::row::: :::column::: FILTER :::column-end::: :::column::: REAL :::column-end::: :::column::: XMLEXISTS :::column-end::: :::row-end::: :::row::: :::column::: FIRST :::column-end::: :::column::: RECURSIVE :::column-end::: :::column::: XMLFOREST :::column-end::: :::row-end::: :::row::: :::column::: FLOAT :::column-end::: :::column::: REF :::column-end::: :::column::: XMLITERATE :::column-end::: :::row-end::: :::row::: :::column::: FOUND :::column-end::: :::column::: REFERENCING :::column-end::: :::column::: XMLNAMESPACES :::column-end::: :::row-end::: :::row::: :::column::: FREE :::column-end::: :::column::: REGR_AVGX :::column-end::: :::column::: XMLPARSE :::column-end::: :::row-end::: :::row::: :::column::: FULLTEXTTABLE :::column-end::: :::column::: REGR_AVGY :::column-end::: :::column::: XMLPI :::column-end::: :::row-end::: :::row::: :::column::: FUSION :::column-end::: :::column::: REGR_COUNT :::column-end::: :::column::: XMLQUERY :::column-end::: :::row-end::: :::row::: :::column::: GENERAL :::column-end::: :::column::: REGR_INTERCEPT :::column-end::: :::column::: XMLSERIALIZE :::column-end::: :::row-end::: :::row::: :::column::: GET :::column-end::: :::column::: REGR_R2 :::column-end::: :::column::: XMLTABLE :::column-end::: :::row-end::: :::row::: :::column::: GLOBAL :::column-end::: :::column::: REGR_SLOPE :::column-end::: :::column::: XMLTEXT :::column-end::: :::row-end::: :::row::: :::column::: GO :::column-end::: :::column::: REGR_SXX :::column-end::: :::column::: XMLVALIDATE :::column-end::: :::row-end::: :::row::: :::column::: GROUPING :::column-end::: :::column::: REGR_SXY :::column-end::: :::column::: YEAR :::column-end::: :::row-end::: :::row::: :::column::: HOLD :::column-end::: :::column::: REGR_SYY :::column-end::: :::column::: ZONE :::column-end::: :::row-end::: ## See Also [SET QUOTED_IDENTIFIER (Transact-SQL)](../../t-sql/statements/set-quoted-identifier-transact-sql.md) [ALTER DATABASE Compatibility Level (Transact-SQL)](../../t-sql/statements/alter-database-transact-sql-compatibility-level.md)