Attribute

LeadingUnderscoreReplacement

Purpose

Specifies the string of characters that replace leading underscores used in identifiers for collections, documents, and arrays.

Valid Values

string

where:

string
is comprised of any Unicode character or group of characters, including spaces.

For example, MongoDB collections automatically include the _id field. By specifying LeadingUnderscoreReplacement=XX, the _id field becomes the XXID column in the relational view of the data.

The value for this config option is specified as a key=value pair in the Config Options field. See "Config options" for details.

Notes

  • The Table Wizard builds table and column identifiers by concatenating the names of nested collections, documents, and arrays. When specifying a value for LeadingUnderscoreReplacement, consider that the total length of identifiers must not exceed 128 characters in length.

Default

None. When no value is specified, a leading underscore is used in identifiers.

GUI Tab

For Windows:

The value for config options are specified in the Config Options field on the Advanced tab.

For UNIX/Linux:

The value for config options are specified in the Config Options field on the Schema Tool. For details, see "Starting the Schema Tool on UNIX/Linux."

See also