Reserved words and keywords
Many keywords are also reserved words. You can use reserved words anywhere you use identifiers, as long as you quote them.
Below you can find all the words which are reserved or look like.
Non-reserved keywords
Non-reserved keywords have a special meaning in some contexts, but can be used as identifiers in others. You can use non-reserved keywords as aliases.
| Keywords |
Reserved | Non-reserved |
| ABSOLUTE |
N |
| ADD |
R |
| ALL |
R |
| ALTER |
R |
| AND |
R |
| ANY |
R |
| APPLY |
N |
| APPROX_COUNT_DISTINCT |
N |
| AS |
R |
| ASC |
R |
| AUTO |
N |
| BEGIN |
R |
| BETWEEN |
R |
| BIGINT |
N |
| BINARY |
N |
| BIT |
N |
| BREAK |
R |
| BY |
R |
| CASE |
R |
| CAST |
N |
| CATCH |
N |
| CHAR |
N |
| CHARACTER |
N |
| CLOSE |
R |
| CLUSTERED |
R |
| COLLATE |
R |
| COMMIT |
R |
| COMPUTE |
R |
| CONFIGURATION |
N |
| CONNECTION |
N |
| CONSTRAINT |
R |
| CONTAINS |
R |
| CONTINUE |
R |
| CONVERT |
R |
| COUNT |
N |
| COUNT_BIG |
N |
| CREATE |
R |
| CROSS |
R |
| CUME_DIST |
N |
| CURSOR |
R |
| DATABASE |
R |
| DATE |
N |
| DATETIME |
N |
| DATETIME2 |
N |
| DATETIMEOFFSET |
N |
| DEALLOCATE |
R |
| DEC |
N |
| DECIMAL |
N |
| DECLARE |
R |
| DEFAULT |
R |
| DELAY |
N |
| DELETE |
R |
| DELETED |
N |
| DENY |
R |
| DESC |
R |
| DISABLE |
N |
| DISTINCT |
R |
| DOUBLE_PRECISION |
N |
| DROP |
R |
| ELSE |
R |
| ENABLE |
N |
| END |
R |
| ESCAPE |
R |
| EXCEPT |
R |
| EXECUTE |
R |
| EXECUTE_ON |
N |
| EXISTS |
R |
| EXPAND |
N |
| EXPLICIT |
N |
| FETCH |
R |
| FIRST |
N |
| FIRST_VALUE |
N |
| FLOAT |
N |
| FOR |
R |
| FORCE |
N |
| FORCESCAN |
N |
| FORCESEEK |
N |
| FOREIGN |
R |
| FROM |
R |
| FULL |
R |
| FUNCTION |
R |
| GEOGRAPHY |
N |
| GEOMETRY |
N |
| GOTO |
R |
| GRANT |
R |
| GROUP |
R |
| GROUPING |
N |
| HASH |
N |
| HAVING |
R |
| HIERARCHYID |
N |
| HOLDLOCK |
R |
| IDENTITY |
R |
| IF |
R |
| IMAGE |
N |
| IN |
R |
| INCLUDE |
N |
| INDEX |
R |
| INNER |
R |
| INSERT |
R |
| INSERTED |
N |
| INT |
N |
| INTEGER |
N |
| INTERSECT |
R |
| INTO |
R |
| IS |
R |
| ISOLATION |
N |
| JOIN |
R |
| KEY |
R |
| LAG |
N |
| LAST |
N |
| LAST_VALUE |
N |
| LEAD |
N |
| LEFT |
R |
| LEVEL |
N |
| LIKE |
R |
| LOCK_TIMEOUT |
N |
| LOOP |
N |
| MARK |
N |
| MATCHED |
N |
| MAX |
N |
| MERGE |
R |
| MIN |
N |
| MONEY |
N |
| NATIONAL |
R |
| NCHAR |
N |
| NEXT |
N |
| NOLOCK |
N |
| NONCLUSTERED |
R |
| NOT |
R |
| NOWAIT |
N |
| NTEXT |
N |
| NULL |
R |
| NUMERIC |
N |
| NVARCHAR |
N |
| OF |
R |
| OFF |
R |
| OFFSET |
R |
| ON |
R |
| ONLY |
N |
| OPEN |
R |
| OPTIMIZE |
N |
| OPTION |
R |
| OR |
R |
| ORDER |
R |
| OUT |
N |
| OUTER |
R |
| OUTPUT |
N |
| OVER |
R |
| PAGLOCK |
N |
| PARTITION |
N |
| PATH |
N |
| PERCENT_RANK |
N |
| PERCENTILE_CONT |
N |
| PERCENTILE_DISC |
N |
| PHYSICAL |
N |
| POOL |
N |
| PRIMARY |
R |
| PRIMARY_COPY |
N |
| PRINT |
R |
| PRIOR |
N |
| PRIVILEGES |
N |
| PROCEDURE |
R |
| QUOTEDDEFAULT |
N |
| RAISE_ERROR |
R |
| RANGE |
N |
| RAW |
N |
| READCOMMITED |
N |
| READCOMMITTEDLOCK |
N |
| READONLY |
N |
| READPAST |
N |
| READUNCOMMITED |
N |
| REAL |
N |
| REFERENCES |
R |
| RELATIVE |
N |
| REMOTE |
N |
| REMOVE |
N |
| REPEATABLEREAD |
N |
| REPLICATION |
R |
| RETURN |
R |
| REVOKE |
R |
| RIGHT |
R |
| ROLLBACK |
R |
| ROW |
N |
| ROWCOUNT |
R |
| ROWLOCK |
N |
| ROWS |
N |
| ROWVERSION |
N |
| SCHEME |
R |
| SECONDARY_COPY |
N |
| SELECT |
R |
| SERIALIZABLE |
N |
| SET |
R |
| SETS |
N |
| SKIPCACHE |
N |
| SMALLDATETIME |
N |
| SMALLINT |
N |
| SMALLMONEY |
N |
| SNAPSHOT |
N |
| SOME |
R |
| SOURCE |
N |
| SPARK_SHUFFLE_PARTITIONS |
N |
| SPLIT |
N |
| SQL_VARIANT |
N |
| STATISTICS |
R |
| SWITCH |
N |
| TABLE |
R |
| TABLOCK |
N |
| TABLOCKX |
N |
| TARGET |
N |
| TEXT |
N |
| THEN |
R |
| TIME |
N |
| TIMESTAMP |
N |
| TINYINT |
N |
| TO |
R |
| TOP |
R |
| TRANSACTION |
R |
| TRIGGER |
R |
| TRUNCATE |
R |
| TRY |
N |
| UNION |
R |
| UNIQUE |
R |
| UNIQUEIDENTIFIER |
N |
| UNKNOWN |
N |
| UPDATE |
R |
| UPDLOCK |
N |
| USE |
R |
| USED |
N |
| USING |
N |
| VALUES |
R |
| VARBINARY |
N |
| VARCHAR |
N |
| VARYING |
R |
| VIEW |
R |
| VIEWS |
N |
| VIRTUAL |
N |
| WAITFOR |
R |
| WHEN |
R |
| WHERE |
R |
| WHILE |
R |
| WITH |
R |
| XLOCK |
N |
| XML |
N |