The invention discloses a method for automatically switching between SQL search result column titles and codes. The method of automatically switching between the SQL search result column titles and the codes includes the steps of 1, configuring source list columns to shown metadata; 2, obtaining corresponding relations between SQL search result columns and the source list columns; 3, rewriting SQLsearch statements. The method for automatically switching between the SQL search result column titles and the codes has the advantages that no manual intervention is needed in a whole SQL processingprocedure, a hard-coded working pattern, regarding switching between the column display titles and the codes, of traditional data visualization is changed, workloads of program developers are reduced,manual errors in a switching process are avoided, and finally, the working efficiency and quality of data visualization are improved.