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.

Examples

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:

Applying this directive:

results in this record:

 

Created in 2020 by Google Inc.