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."
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.