May 7, 2008 at 2:42 pm
Hello everyone:
I would appreciate any suggestions how to find this info. I have 350 Tables in DB. There are certain columns repeated in multiple tables. An example:
Name.Birth_Date
Demographics.Date_Of_Birth
How could I find those columns with the same data in different tables since column names are not the same. I was thinking of using key words like 'Birth' in the above example but do not know how to do it or if that is right approach.
Very grateful for suggestions and help.
Thank you
Miriana
May 7, 2008 at 3:20 pm
There is no easy way to do this. You can search information_schema.columns with a like '%birth%' and try to track down columns that contain that name. However if someone had DOB, then this doesn't help.
Really you might be better off spending time documenting the tables and columns so that this type of thing can be more easily determined later.
May 8, 2008 at 6:48 am
I was afraid of that. I will start building Data Dictionary hopefully with help from business community.
Thank you very much Steve for taking the time to respond.
Miriana
I love this site.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply