Idea and Concept

In the intial state of project, generally we start the design of database by putting some abstract information like table name, column name etc in the excel file. In this process we miss important information like default values of columns, comments on columns, table constarints etc. (don't get me wrong if you are really perfectionist!). Even if we put all the inforormation properly, we still have to write the SQL scripts manually. If you design the database in excel and you are looking for a tool to help you then

This small API provides the following opportunities:

  • Standard template to put the table and column information
  • Ability to generate the SQL scripts from excel file
  • Abilty to create excel from existing table in database
  • Group the tables in excel table by module name, table type (Master table, Configuration table, Transaction table) etc.