摘要 |
PROBLEM TO BE SOLVED: To automatic generate a database definition SQL statement by editing information on database specifications, line by line, and generating the SQL statement corresponding to the record size of each piece of information. SOLUTION: The SQL automatic generation system 2 reads in the information of the database specifications 1, line by line (B1). Simultaneously with the read, it is decided which of table information A1, index information A2, and record quantity information A3 the read-in information is (B3). For example, when the read-in information is the table information A1, document file information of the database specifications 1 is edited and a Table definition statement (SQL statement) constituting a database definition SQL statement 3 is outputted. At the same time, the number of bytes needed to store the Table definition statement is calculated as a Table record size according to the 'column attribute' of the information of the database specifications 1 (B4).
|