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