Re: documenting tables version control

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
>