Administrator Guide

9.9.3
- 9.9.4
- 9.9.2
- 9.9.1
- 9.9
- 9.8.4
- 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	ANY_VALUE
AT	APPROX_COUNT
ATTRIBUTES	APPROX_COUNT_DISTINCT
AUTO	APPROX_COUNT_DISTINCT_AGG
BASE64	APPROX_COUNT_DISTINCT_DETAIL
BIGINT	APPROX_MEDIAN, DETERMINISTIC
BINARY	APPROX_PERCENTILE, DETERMINISTIC
BIT	APPROX_PERCENTILE_AGG
BLOB	APPROX_PERCENTILE_DETAIL
CALL	APPROX_SUM,APPROX_RANK
CHARACTER	ATTRIBUTES
CLOB	AUTO
COLUMNS	BASE64
CONTAINED	BEGIN
CONTENT	BIGINT
DATE	BINARY
DATETIME	BIT
DATETIME2	BLOB
DATETIMEOFFSET	CHARACTER
DEC	CLOB
DECIMAL	COLUMNS
DELAY	CONTENT
DISABLE	CONVERT
DISABLE_OPTIMIZED_NESTED_LOOP	COLLATE
DYNAMIC	CONNECT BY PRIOR
ELEMENTS	CONNECT_BY_ISCYCLE
EMPTY	CONNECT_BY_ISLEAF
EVALNAME	CONNECT_BY_ROOT
EXPAND	CONTAINERS
EXTERNALPUSHDOWN	CONTAINS
FAST	CROSS
FAST_FORWARD	CURSOR
FIRST	DATETIME
FLOAT	DATETIME2
FN	DATETIMEOFFSET
FORCE	DAYS
FORCED	DBCLOB
FORCESCAN	DEC
FORCESEEK	DECFLOAT
FORWARD_ONLY	DOCUMENT
GLOBAL	DOUBLE
HASH	ELEMENTS
HINT	EMPTY
IIF	END
IMAGE	ENTITYESCAPING
INCLUDING	EVALNAME
INDICATOR	EXCEPT
INSENSITIVE	EXCLUDING
INT	EXIT
INTEGER	EXPLICIT
KEEP	FETCH
KEEPFIXED	FIRST
KEYSET	FULL
LABEL	HOLDLOCK
LARGE	HOUR
LAST	IF
LEVEL	ILIKE
LOCAL	IMAGE
LOGIN	INCLUDING
LOOP	INDICATOR
MAXDOP	INNER
MAXRECURSION	INT
MAX_GRANT_PERCENT	IREGEXP
MIN_GRANT_PERCENT	JOIN
MONEY	JOINS
NATURAL	LARGE
NEXT	LAST
NO	LIKE2
NOCOUNT	LIKE4
NOEXPAND	LIKEC
NOLOCK	LOCKED
NONE	MONEY
NOWAIT	MONTHS
NTEXT	MULTISET
NUMERIC	NATURAL
NVARCHAR	NCHAR
OBJECT	NO
OFFSET	NOENTITYESCAPING
OPTIMISTIC	NOHOLDLOCK
OPTIMIZE	NOSCHEMACHECK
ORDINALITY	NTEXT
OUTPUT	NULLS
PAGLOCK	NUMERIC
PARAMETERIZATION	NVARCHAR
PARSE	OBJECT
PATH	OFF
PRECEDING	OFFSET
PRECISION	OPENXML
PRESERVE	ORA_SHARD_ID
QUOTED_IDENTIFIER	ORDINALITY
RAW	OUTER
READCOMMITTED	OVER
READCOMMITTEDLOCK	PARTITION
READPAST	PASSING
READUNCOMMITTED	PATH
READ_ONLY	PRESERVE
REAL	QUALIFY
RECOMPILE	QUOTED_IDENTIFIER
REDISTRIBUTE	REAL
REDUCE	REF
REF	REGEXP
RELATIVE	RETURNING
REPEATABLE	RLIKE
REPEATABLEREAD	ROOT
RESULT	ROUND_TIES_TO_EVEN
ROBUST	ROWCOUNT
ROOT	SAMPLE
ROW	SCHEMACHECK
ROWLOCK	SEMI
ROWS	SEQUENCE
SCROLL	SHARDS
SCROLL_LOCKS	SHARED
SERIALIZABLE	SIBLINGS
SETS	SMALLDATETIME
SIMPLE	SMALLMONEY
SMALLDATETIME	SOME
SMALLINT	STRIP
SMALLMONEY	SUBPARTITION
SNAPSHOT	SYS_CONNECT_BY_PATH
SPATIAL_WINDOW_MAX_CELLS	SYSTIMESTAMP
START	TEXT
STATIC	TINYINT
STRING_SPLIT	TO_UTC_TIMESTAMP_TZ
SYSTEM	UPDATE
SYSTEM_TIME	USE
TABLOCK	USING
TABLOCKX	VARBINARY
TEXT	WAIT
TINYINT	WHEN
TRY_CAST	WITH
TRY_CONVERT	XMLAGG
TRY_PARSE	XMLATTRIBUTES
TYPE_WARNING	XMLCAST
UNBOUNDED	XMLCOLATTVAL
UNDEFINED	XMLCONCAT
UNKNOWN	XMLDOCUMENT
UPDLOCK	XMLELEMENT
USING	XMLEXISTS
VARBINARY	XMLFOREST
VARCHAR	XMLNAMESPACES
VIEWS	XMLPARSE
WRITE	XMLPI
XLOCK	XMLQUERY
XML	XMLROW
XMLAGG	XMLSERIALIZE
XMLATTRIBUTES	XMLTABLE
XMLCAST	XMLXSROBJECTID
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