We keep the DDL statements for any tables in our subversion code repository just like any other programming code. Takes only a moment then all history or changes is available and comparable. svnserve on our linux server, svn workbench on my ubuntu laptop, all open source :)
Tim Clarke On 05/05/15 21:13, Suresh Raja wrote: > > Hi All: > > > I have tables with different versions in the same schema. Like > T1a, T1b, T1c > T2a, T2b, T2c, T2d > .... > ... > etc. > > > I'm interested in documenting various version of tables, may be in > excel sheet or may be in another schema in the database. I would like > to store information on table name, column names, column order, pry > key column etc. Also is there a way I can reverse engineer from the > database itself. > > Let me know if anybody any suggestion or format that they used. I > appreciate all your help and shall be suitably acknowledged. > > Thanks, > -Suresh Raja >
