Updating a Custom Table Schema

This topic provides how to update a custom table.

PUT -- /pem/sql-service/config is used to update a custom table schema configuration.

The following example shows a fifth column – CUSTOMER_ZIP being added to the CUSTOMER table.

Sample JSON:

Input: {
,"columnName1":"CUSTOMER_ID"
,"columnName2":"CUSTOMER_NAME"
,"columnName3":"CUSTOMER_ADDRESS"
,"columnName4":"CUSTOMER_PHN"
,"columnName5":"CUSTOMER_ZIP"
."distinctColumnName":"CUSTOMER_NAME"
# Used to perform distinct or unique operations on named column
,"seqId":1,
# To match table configuration for API reference
,"tableName":"CUSTOMER"
,"whereColumnName1":"any column name from table"
# To perform filter operations
,"whereColumnName2":"any column name from table"
,"whereColumnName3":"any column name from table"
}

Result: