Clean Unused Column By Joget Form

 
1
0
-1

hi, since joget automatically created column table when we designing form, this will leave a lot of unused column on table. is there  any script that can detect which column is used by the form, so we can do some housekeeping to drop unused column on specific tables.


    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      Hi there,

      Please see Clean Up Unused Columns in Form Data Table.

      Thanks.

      Hugo

      1. ayohmang

        many thanks. 

      CommentAdd your comment...
    2.  
      2
      1
      0

      Hi, don't know is there any script that can detect which column is used by the form...

      But what I know is that you can use HeidiSQL to check which column data is always updated, which is unused, especially column with null value.

        CommentAdd your comment...