Monday, December 18, 2017  
You are here:  Knowledge base * MSSQL Server * Reserved words Register  Login
MS SQL Reserved words or forbidden words

You can not use these words as column or field names, because they are used within MS SQL

 These are the reserved words for MS SQL:

ADD CURRENT_TIMESTAMP GROUP OPENQUERY SERIALIZABLE
ALL CURRENT_USER HAVING OPENROWSET SESSION_USER
ALTER CURSOR HOLDLOCK OPTION SET
AND DATABASE IDENTITY OR SETUSER
ANY DBCC IDENTITYCOL ORDER SHUTDOWN
AS DEALLOCATE IDENTITY_INSERT OUTER SOME
ASC DECLARE IF OVER STATISTICS
AUTHORIZATION DEFAULT IN PERCENT SUM
AVG DELETE INDEX PERM SYSTEM_USER
BACKUP DENY INNER PERMANENT TABLE
BEGIN DESC INSERT PIPE TAPE
BETWEEN DISK INTERSECT PLAN TEMP
BREAK DISTINCT INTO PRECISION TEMPORARY
BROWSE DISTRIBUTED IS PREPARE TEXTSIZE
BULK DOUBLE ISOLATION PRIMARY THEN
BY DROP JOIN PRINT TO
CASCADE DUMMY KEY PRIVILEGES TOP
CASE DUMP KILL PROC TRAN
CHECK ELSE LEFT PROCEDURE TRANSACTION
CHECKPOINT END LEVEL PROCESSEXIT TRIGGER
CLOSE ERRLVL LIKE PUBLIC TRUNCATE
CLUSTERED ERROREXIT LINENO RAISERROR TSEQUAL
COALESCE ESCAPE LOAD READ UNCOMMITTED
COLUMN EXCEPT MAX READTEXT UNION
COMMIT EXEC MIN RECONFIGURE UNIQUE
COMMITTED EXECUTE MIRROREXIT REFERENCES UPDATE
COMPUTE EXISTS NATIONAL REPEATABLE UPDATETEXT
CONFIRM EXIT NOCHECK REPLICATION USE
CONSTRAINT FETCH NONCLUSTERED RESTORE USER
CONTAINS FILE NOT RESTRICT VALUES
CONTAINSTABLE FILLFACTOR NULL RETURN VARYING
CONTINUE FLOPPY NULLIF REVOKE VIEW
CONTROLROW FOR OF RIGHT WAITFOR
CONVERT FOREIGN OFF ROLLBACK WHEN
COUNT FREETEXT OFFSETS ROWCOUNT WHERE
CREATE FREETEXTTABLE ON ROWGUIDCOL WHILE
CROSS FROM ONCE RULE WITH
CURRENT FULL ONLY SAVE WORK
CURRENT_DATE GOTO OPEN SCHEMA WRITETEXT
CURRENT_TIME GRANT OPENDATASOURCE SELECT

These are the reserved words in MS SQL Field names:

binary decimal nchar smalldatetime tinyint
bit float ntext smallint uniqueidentifier
char image numeric smallmoney varbinary
cursor int nvarchar text varchar
datetime money real timestamp

 


 
Home  |  Company  |  Products  |  Contact  |  Downloads  |  Knowledge base
Copyright (c) 2017 FRENT IT   |  Privacy Statement  |  Terms Of Use