Method and device for changing tables in database

Abstract

The invention provides a method and device for changing tables in a database. The method comprises the steps: obtaining a change instruction for a target table in the database, wherein the change instruction comprises corresponding change information; adopting a preset DDL grammar rule, and generating a DDL script based on the target table in the database and the corresponding change information;and automatically calling and executing the DDL script so as to change the target table in the database. According to the method, the change information of the table can be converted into the DDL script, so that the table is changed, and then the table change accuracy is improved, and the table change operation is simple, and the usability is high, and the generalizability is high; and the DDL script is automatically called and executed, so that missing submission of a change file of the table can be avoided, and the consistency of each environment table is further ensured, and the data governance and maintenance difficulty is reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for changing tables in a database. Background technique [0002] With the continuous development of the Internet and information technology, the release frequency of application software versions is getting faster and faster. The project corresponding to each version of application software contains multiple sub-applications, and each sub-application calls several databases. Each database contains The database instance (dbname), database owner (dbowner), tables, and data stored procedures. The version release of the application software is actually to package all the changed tables, data storage procedures, codes and other programs under the current version into a version package, use the push tool to push the code to the version library, and deploy the version library to realize the version change. [0003] At present, to change the table of the database c...

AI Technical Summary

Problems solved by technology

[0004] However, with the exponential growth of data, when the amount of table change data is huge, manually generating and submitting table change files will reduce the release rate of the version, and when the table is modified in the development environment or test environment, but the table change file is omitted, It will cause inconsistency between the actual deployment environment and the development environment table, causing data errors and increasing the difficulty of subsequent data governance and maintenance

Images