Network Management

List of reserved words in Custom Property names

This article provides the list of Reserved Words that should not be used in Custom Property names. Customer will get an error for Ambiguous Column Name if they are used.

First published date

10/19/2018 9:40 PM

Last published date

5/12/2026 8:55 PM

Overview

This article provides the list of words reserved for use by the system and therefore not available to be used in custom property names. 

Product section

Orion Platform

Cause

Certain words being used as Custom Properties can break SQL query execution.

Resolution

The following reserved words may not be used in custom property names. This does not apply to the custom property field/value:

  • ABSOLUTE
  • ACTION
  • ADA
  • ADD
  • ADMIN
  • ADDRESS
  • AFTER
  • AGGREGATE
  • ALIAS
  • ALL
  • ALLOCATE
  • ALTER
  • AND
  • ANY
  • APPLICATION
  • APPLICATIONS
  • ARE
  • ARRAY
  • AS
  • ASC
  • ASSERTION
  • AT
  • AUTHORIZATION
  • AVG
  • BACKUP
  • BEFORE
  • BEGIN
  • BETWEEN
  • BINARY
  • BIT_LENGTH
  • BIT
  • BLOB
  • BOOLEAN
  • BOTH
  • BREADTH
  • BREAK
  • BROWSE
  • BULK
  • BY
  • CALL
  • CASCADE
  • CASCADED
  • CASE
  • CAST
  • CATALOG
  • CATEGORY
  • CHAR_LENGTH
  • CHAR
  • CHARACTER_LENGTH
  • CHARACTER
  • CHECK
  • CHECKPOINT
  • CLASS
  • CLOB
  • CLOSE
  • CLUSTERED
  • COALESCE
  • COLLATE
  • COLLATION
  • COLUMN
  • COMMIT
  • COMPLETION
  • COMPUTE
  • CONNECT
  • CONNECTION
  • CONSTRAINT
  • CONSTRAINTS
  • CONSTRUCTOR
  • CONTAINS
  • CONTAINSTABLE
  • CONTINUE
  • CONVERT
  • CORRESPONDING
  • COUNT
  • CPUCOUNT
  • CREATE
  • CROSS
  • CUBE
  • CURRENT_DATE
  • CURRENT_PATH
  • CURRENT_ROLE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURRENT_USER
  • CURRENT
  • CURSOR
  • CYCLE
  • DATA
  • DATABASE
  • DATE
  • DATETIME
  • DAY
  • DBCC
  • DEALLOCATE
  • DEC
  • DECIMAL
  • DECLARE
  • DEFAULT
  • DEFERRABLE
  • DEFERRED
  • DELETE
  • DENY
  • DEPTH
  • DEREF
  • DESC
  • DESCRIBE
  • DESCRIPTOR
  • DESTROY
  • DESTRUCTOR
  • DETERMINISTIC
  • DIAGNOSTICS
  • DICTIONARY
  • DISCONNECT
  • DISK
  • DISTINCT
  • DISTRIBUTED
  • DOMAIN
  • DOUBLE
  • DROP
  • DUMMY
  • DUMP
  • DYNAMIC
  • EACH
  • ELSE
  • END
  • END-EXEC
  • EQUALS
  • ERRLVL
  • ESCAPE
  • EVERY
  • EXCEPT
  • EXCEPTION
  • EXEC
  • EXECUTE
  • EXISTS
  • EXIT
  • EXTERNAL
  • EXTRACT
  • FALSE
  • FETCH
  • FILE
  • FILLFACTOR
  • FIRST
  • FLOAT
  • FOR
  • FOREIGN
  • FORTRAN
  • FOUND
  • FREE
  • FREETEXT
  • FREETEXTTABLE
  • FROM
  • FULL
  • FUNCTION
  • GENERAL
  • GET
  • GLOBAL
  • GO
  • GOTO
  • GRANT
  • GROUP
  • GROUPING
  • HAVING
  • HOLDLOCK
  • HOST
  • HOUR
  • IDENTITY_INSERT
  • IDENTITY
  • IDENTITYCOL
  • IF
  • IGNORE
  • IMMEDIATE
  • IN
  • INCLUDE
  • INDEX
  • INDICATOR
  • INITIALIZE
  • INITIALLY
  • INNER
  • INOUT
  • INPUT
  • INSENSITIVE
  • INSERT
  • INT
  • INTEGER
  • INTERFACES (NCM)
  • INTERSECT
  • INTERVAL
  • INTO
  • IS
  • ISOLATION
  • ITERATE
  • JOIN
  • KEY
  • KILL
  • LANGUAGE
  • LARGE
  • LAST
  • LATERAL
  • LEADING
  • LEFT
  • LESS
  • LEVEL
  • LIKE
  • LIMIT
  • LIMITATION
  • LINENO
  • LOAD
  • LOCAL
  • LOCALTIME
  • LOCALTIMESTAMP
  • LOCATOR
  • LOWER
  • MAP
  • MATCH
  • MAX
  • MIN
  • MINUTE
  • MODIFIES
  • MODIFY
  • MODULE
  • MONTH
  • NAME
  • NAMES
  • NATIONAL
  • NATURAL
  • NCHAR
  • NCLOB
  • NEW
  • NEXT
  • NO
  • NOCHECK
  • NONCLUSTERED
  • NONE
  • NOT
  • NULL
  • NULLIF
  • NUMERIC
  • OBJECT
  • OCTET_LENGTH
  • OF
  • OFF
  • OFFSETS
  • OLD
  • ON
  • ONLY
  • OPEN
  • OPENDATASOURCE
  • OPENQUERY
  • OPENROWSET
  • OPENXML
  • OPERATION
  • OPTION
  • OR
  • ORDER
  • ORDINALITY
  • ORIONGROUPNAME
  • OUT
  • OUTER
  • OUTPUT
  • OVER
  • OVERLAPS
  • PAD
  • PARAMETER
  • PARAMETERS
  • PARENTID
  • PARTIAL
  • PASCAL
  • PATH
  • PERCENT
  • PERCENTAGE
  • PLAN
  • POSITION
  • POSTFIX
  • PRECISION
  • PREFIX
  • PREORDER
  • PREPARE
  • PRESERVE
  • PRIMARY
  • PRINT
  • PRIOR
  • PRIVILEGES
  • PROC
  • PROCEDURE
  • PUBLIC
  • RAISERROR
  • READ
  • READS
  • READTEXT
  • REAL
  • RECONFIGURE
  • RECURSIVE
  • REF
  • REFERENCES
  • REFERENCING
  • RELATIVE
  • REPLICATION
  • RESTORE
  • RESTRICT
  • RESULT
  • RETURN
  • RETURNS
  • REVOKE
  • RIGHT
  • ROLE
  • ROLLBACK
  • ROLLUP
  • ROUTER
  • ROUTINE
  • ROW
  • ROWCOUNT
  • ROWGUIDCOL
  • ROWS
  • RULE
  • SAFEPERIODINSECONDS
  • SAVE
  • SAVEPOINT
  • SCHEMA
  • SCOPE
  • SCROLL
  • SEARCH
  • SECOND
  • SECTION
  • SELECT
  • SEQUENCE
  • SESSION_USER
  • SESSION
  • SET
  • SETS
  • SETUSER
  • SHUTDOWN
  • SIZE
  • SMALLINT
  • SOME
  • SPACE
  • SPECIFIC
  • SPECIFICTYPE
  • SQL
  • SQLCA
  • SQLCODE
  • SQLERROR
  • SQLEXCEPTION
  • SQLSTATE
  • SQLWARNING
  • START
  • STATE
  • STATEMENT
  • STATIC
  • STATISTICS
  • STRUCTURE
  • SUBSTRING
  • SUM
  • SYSTEM_USER
  • TABLE
  • TEMPORARY
  • TERMINATE
  • TEXTSIZE
  • THAN
  • THEN
  • TIME
  • TIMESTAMP
  • TIMEZONE_HOUR
  • TIMEZONE_MINUTE
  • TO
  • TOP
  • TRAILING
  • TRAN
  • TRANSACTION
  • TRANSLATE
  • TRANSLATION
  • TRANSLATION
  • TREAT
  • TRIGGER
  • TRIM
  • TRUE
  • TRUNCATE
  • TSEQUAL
  • TYPE
  • UNDER
  • UNION
  • UNIQUE
  • UNKNOWN
  • UNNEST
  • UPDATE
  • UPDATETEXT
  • UPPER
  • USAGE
  • USE
  • USER
  • USING
  • VALUE
  • VALUES
  • VARCHAR
  • VARIABLE
  • VARYING
  • VIEW
  • WAITFOR
  • WHEN
  • WHENEVER
  • WHERE
  • WHILE
  • WITH
  • WITHOUT
  • WORK
  • WRITE
  • WRITETEXT
  • YEAR
  • ZONE

It should be noted that all custom names used within the SolarWinds Platform should be unique for an object type regardless of whether they are to be used by different SolarWinds products. instead of creating two node names called"foobar", you would need to create "foobar1" and "foobar2".
 

Additional information is shown below:

Default system properties of a SolarWinds Platform installation