asked on

Building a Data Dictionary w Sybase

Hi All,

I'm trying to build a data dictionary for my Sybase tables. I found the following code which works great. But I also need the datatype. Can anyone point me to the correct location?

select O.name as "Table"
, C.name as "Column", C.length as "Length"
from sysobjects O
, syscolumns C
where O.id = C.id
and O.type = "U" -- user tables only
order by O.name, C.colid

grant300

You can do things this way but there is a much easier and nicer tool for doing this stuff and it is free.

Find a copy of the Sybase Client for Windows installation CD and install the copy of PowerDesigner Physical Architect. It is included for free on the CD and is an incredibly powerful tool.

You can reverse engineer your entire database including tables, indexes, views, defaults, user data types, and stored procedures.

You can then pretty up the diagram so you have a nice data model to use.

In addition, though it is hard to figure out how to use, there is a very powerful reporting tool that you can use to create summary and detailed reports in just about any form you want. Pretty stuff too with control over fonts and formats and the columns displayed, etc.

You can also go in to the table definitions and add descriptions then drill to the fields and add descriptions there as well. This makes the dictionary reports much more useful.

Believe me when I say that this will save you a boat load of time and effort and you will wind up with a very professional product when you are done.

Regards,
Bill

ASKER CERTIFIED SOLUTION

simongv

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial