Skip to content

gw_fct_admin_manage_fields

Edgar Fuste edited this page Nov 2, 2021 · 1 revision

Description

Function to admin fields on tables used on sql file to prevent conflict when field exists

Input example

SELECT gw_fct_admin_manage_fields($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"data":{"action":"ADD","table":"arc", "column":"addvalue", 
"dataType":"varchar(16)", "isUtils":"False"}}$$)

SELECT gw_fct_admin_manage_fields($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"data":{"action":"DROP","table":"inp_tank", "column":"to_arc"}}$$);

Output example

Clone this wiki locally