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!
tablename, columnname, datatype, comment
Easy enough! Now how do I populate it?! I'm not going through 350,000 columns by hand!