数据库表定义的动态修改方法

Dynamic modification method of database table definition

数据库维护是MIS应用软件中经常遇到的难题,提出了一种新的面向数据库维护的数据库表定义动态修改方法。首先深入分析了数据库表定义的动态修改内容,给出SQL Server应用案例;其次提出利用SQL Server的数据字典和系统表,设计友好灵活的操作界面,创建新颖的存储过程来具体实现的方法;最后该方法应用于财务软件系统中。该方法简单,实用,高效,给应用程序带来许多灵活性和可适应性。

It is a common difficult problem for MIS application software to maintain the database, A kind of new dynamic modification method of database table definition oriented-database maintenance was put forward. Firstly, the dynamic modification of database table definition was analyzed, and SQL server application case was provided. Secondly it provided the way to use SQL server＇s data dictionary and the system table, design friendly and flexible operating interface, create the corresponding store process. Finally this method applies in financial software system simply, expertly and effectively, which brought more flexibilities and compatibilities for the application.