Administrator Guide

9.8.4
- 9.9.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.9
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Database Keywords

Dynamic Data Masking reserves certain keywords that the database parsers cannot parse. If you use these keywords in an SQL query when you form a rule, the query might fail. For example, if a column name in the SQL query contains one of these keywords, you might receive an invalid character error.

The following table lists the database keywords for Microsoft SQL Server and Oracle databases:

Keywords for Microsoft SQL Server Databases	Keywords for Oracle Databases
ABSOLUTE	ABSENT
APPLY	ATTRIBUTES
AT	AUTO
ATTRIBUTES	BASE64
AUTO	BEGIN
BASE64	BIGINT
BIGINT	BINARY
BINARY	BIT
BIT	BLOB
BLOB	CHARACTER
CALL	CLOB
CHARACTER	COLUMNS
CLOB	CONTENT
COLUMNS	CONVERT
CONTAINED	CROSS
CONTENT	DATETIME
DATE	DATETIME2
DATETIME	DATETIMEOFFSET
DATETIME2	DBCLOB
DATETIMEOFFSET	DEC
DEC	DECFLOAT
DECIMAL	DOCUMENT
DELAY	DOUBLE
DISABLE	ELEMENTS
DISABLE_OPTIMIZED_NESTED_LOOP	EMPTY
DYNAMIC	END
ELEMENTS	ENTITYESCAPING
EMPTY	EVALNAME
EVALNAME	EXCEPT
EXPAND	EXCLUDING
EXTERNALPUSHDOWN	EXIT
FAST	EXPLICIT
FAST_FORWARD	FIRST
FIRST	FULL
FLOAT	HOLDLOCK
FN	IF
FORCE	ILIKE
FORCED	IMAGE
FORCESCAN	INCLUDING
FORCESEEK	INDICATOR
FORWARD_ONLY	INNER
GLOBAL	INT
HASH	IREGEXP
HINT	JOIN
IIF	LARGE
IMAGE	LAST
INCLUDING	LIKE2
INDICATOR	LIKE4
INSENSITIVE	LIKEC
INT	MONEY
INTEGER	NATURAL
KEEP	NCHAR
KEEPFIXED	NO
KEYSET	NOENTITYESCAPING
LABEL	NOHOLDLOCK
LARGE	NOSCHEMACHECK
LAST	NTEXT
LEVEL	NULLS
LOCAL	NUMERIC
LOGIN	NVARCHAR
LOOP	OBJECT
MAXDOP	OFF
MAXRECURSION	OFFSET
MAX_GRANT_PERCENT	OPENXML
MIN_GRANT_PERCENT	ORDINALITY
MONEY	OUTER
NATURAL	OVER
NEXT	PARTITION
NO	PASSING
NOCOUNT	PATH
NOEXPAND	PRESERVE
NOLOCK	QUALIFY
NONE	QUOTED_IDENTIFIER
NOWAIT	REAL
NTEXT	REF
NUMERIC	REGEXP
NVARCHAR	RETURNING
OBJECT	RLIKE
OFFSET	ROOT
OPTIMISTIC	ROWCOUNT
OPTIMIZE	SAMPLE
ORDINALITY	SCHEMACHECK
OUTPUT	SEMI
PAGLOCK	SEQUENCE
PARAMETERIZATION	SHARED
PARSE	SIBLINGS
PATH	SMALLDATETIME
PRECEDING	SMALLMONEY
PRECISION	SOME
PRESERVE	STRIP
QUOTED_IDENTIFIER	SUBPARTITION
RAW	SYSTIMESTAMP
READCOMMITTED	TEXT
READCOMMITTEDLOCK	TINYINT
READPAST	USE
READUNCOMMITTED	USING
READ_ONLY	VARBINARY
REAL	WAIT
RECOMPILE	WHEN
REDISTRIBUTE	XMLAGG
REDUCE	XMLATTRIBUTES
REF	XMLCAST
RELATIVE	XMLCOLATTVAL
REPEATABLE	XMLCONCAT
REPEATABLEREAD	XMLDOCUMENT
RESULT	XMLELEMENT
ROBUST	XMLEXISTS
ROOT	XMLFOREST
ROW	XMLNAMESPACES
ROWLOCK	XMLPARSE
ROWS	XMLPI
SCROLL	XMLQUERY
SCROLL_LOCKS	XMLROW
SERIALIZABLE	XMLSERIALIZE
SETS	XMLTABLE
SIMPLE	XMLXSROBJECTID
SMALLDATETIME
SMALLINT
SMALLMONEY
SNAPSHOT
SPATIAL_WINDOW_MAX_CELLS
START
STATIC
STRING_SPLIT
SYSTEM
SYSTEM_TIME
TABLOCK
TABLOCKX
TEXT
TINYINT
TRY_CAST
TRY_CONVERT
TRY_PARSE
TYPE_WARNING
UNBOUNDED
UNDEFINED
UNKNOWN
UPDLOCK
USING
VARBINARY
VARCHAR
VIEWS
WRITE
XLOCK
XML
XMLAGG
XMLATTRIBUTES
XMLCAST
XMLCOLATTVAL
XMLCONCAT
XMLDOCUMENT
XMLELEMENT
XMLEXISTS
XMLFOREST
XMLNAMESPACES
XMLPARSE
XMLPI
XMLQUERY
XMLROW
XMLSERIALIZE
XMLTABLE
ZONE

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Database Keywords

Database Keywords