Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hazyboy98
Starting Member
1 Post |
 Posted - 2009-12-30 : 17:45:28
|
| I am new to database management. I am learning Crystal Reports right now, and I am starting to understand a little better how databases work in general, but my company uses a DB2 database that has over 1000 tables and I don't know how they are all connected, so I am having difficulty pulling the data I want into my Crystal Reports. So my question is if there is a way to make a list of all the tables and their column headings with the primary and foreign keys labeled. I think this could be referred to as the database structure or schema. If anyone knows a way to do this, or some other way I can find the way the database is linked, please let me know.Steve H. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-12-30 : 17:49:27
|
| Since this is a Microsoft SQL Server site, you should try posting your DB2 question on a site that specializes in that. There's a DB2 forum over at dbforums.com, so perhaps try your question there.In SQL Server, you could reverse engineer the ERD via SSMS, or you could figure it out via the INFORMATION_SCHEMA views.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
database structure