I inherited a frontend application that populates a Sybase ASA database. This database has over 300 tables, and there is no data dictionary. The users of the application want to create reports using Crystal Reports. They are giving me screen prints from the frontend app and asking where that data is stored in the database. Is there a way to search all of the tables at one time for a value so that I can see which table and field the app is populating?
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
The problem you are having is that you do not have a logical model of your database. For now you can download a trial version of PowerDesigner.
And use the tool to reverse engineer the database you have. What you are really interested is the relationship and constraints among various tables, the primary and foreign keys etc.
In the absence of this tool you can look at a given database by examining tables in sysobjects, syscolumns, sysindexes, syskeys and sysconstraints. However I strongly advise you to use use a modeling tool like PowerDesigner for this purpose.
Dig Deeper on Open source databases
Related Q&A from Mich Talebzadeh
Sybase expert Mich Talebzadeh explains how to log on in ASE.continue reading
Sybase expert Mich Talebzadeh gives fifteen reasons for why Sybase will definitely be around for years to come.continue reading
Sybase expert Mich Talebzadeh explains the syntax for user-defined Sybase functions.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.