Creating a database of what's in my database?

Soldato
Joined
14 Apr 2003
Posts
4,950
Location
Deepest Yorkshire
ok basically at work I look after these banking databases, they have around 800 tables, many of which have around 120 columns in each. I write a lot of reports using lots of these tables and have to join them all over the place, I'm trying to make a database which will show me what columns will match up to other columns: simple query! Only problem is getting the table and column names into the database, ideally I would have a table like so:

tablename, columnname, datatype, comment


Easy enough! Now how do I populate it?! I'm not going through 350,000 columns by hand!
 
Yep it doesn't have any foreign keys! only primary keys, the program sorts out all the validation. It's OPICS by the way.
 
Back
Top Bottom