Can use several documenters, like Ápex Doc or SAP Sybase PowerDesigner, that is very detailed for documented databasess

other solution is using the CTE and PIVOT like the follow script, in the sample I define the tables, but you can use your defined tables and only use the...