Change Column Case directive

The CHANGE-COLUMN-CASE directive changes all column names to either lowercase or uppercase.

Syntax

change-column-case [case]

For case, enter lower, lowercase, upper, or upper case.

If the case specified is incorrect, it defaults to lowercase.

Using this record as an example:

{
  "Id": 1,
  "Gender": "male",
  "FNAME": "Root",
  "lname": "JOLTIE",
  "Address": "67 MARS AVE, MARSCIty, Marsville, Mars"
}

Applying this directive:

change-column-case lower

results in this record:

{
  "id": 1,
  "gender": "MALE",
  "fname": "Root",
  "lname": "Joltie",
  "address": "67 mars ave, marscity, marsville, mars"
}

Applying this directive:

change-column-case upper

results in this record:

{
  "ID": 1,
  "GENDER": "MALE",
  "FNAME": "Root",
  "LNAME": "Joltie",
  "ADDRESS": "67 mars ave, marscity, marsville, mars"
}