Data table field modification method and device, equipment and medium

Abstract

The embodiment of the invention discloses a data table field modification method and device, equipment and a medium. The method comprises the steps of obtaining annotation information of each data table in a database, and constructing an annotation information base; extracting one piece of annotation information from an annotation information base to serve as current annotation information, and searching whether annotation information the same as the current annotation information exists in each data table or not; if the annotation information the same as the current annotation information exists, updating a field corresponding to the current annotation information in each data table according to a corresponding relationship between the current annotation information and the reference field; and extracting the next annotation information as the current annotation information, and repeating the operation until all annotation information is extracted from the annotation information base.According to the embodiment of the invention, the fields with the same annotation information stored in the data tables can be changed according to the annotation information corresponding to the fields, the fields with the same annotation information in each data table can be changed at one time, and the field unification under the same annotation information is effectively realized.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of information processing, and in particular to a method, device, device and medium for modifying database fields. Background technique [0002] The data definition language is used to execute the tasks of the database, and perform operations such as creating, deleting, and modifying the database and various objects in the database. For example: create database or database object, modify database or database object, modify table definition, field, comment, etc.; all definitions on database table definition can be modified through data definition language. Usually, the graphical interface client provided by a third party is used to view the table structure definition, and generate a table definition language according to the field name and field comment of each field to execute, so as to achieve the purpose of modifying the table structure. [0003] The disadvantage of the above sol...

AI Technical Summary

Problems solved by technology

[0003] The disadvantage of the above solution is that each time you need to manually select which table to modify, you can only modify one table at a time. For the same comments corresponding to different fields in the database table, you cannot modify them all at once, and the efficiency of modifying the fields in the database table is low.

Images