Use command scripts

You can enter SQL statements interactively to create the database and tables. In some cases, you might have to create the database and tables two or more times. For example, you might have to create the database again to make a production version after a test version is satisfactory, or you might have to implement the same data model on several computers. To save time and reduce the chance of errors, you can put all the statements to create a database in a file and later re-execute those statements.