I have below requirement and newbie in db testing:
Get a schema from DB. Get a table from schema and find out if a column name say A of that table matches with any other column in any other table in the schema.
If it matches, then find out the column data type and verify if it is same as that of column A.
For e.g, if there are 10 tables and in table 1 there is a column Dept. whose data type is varchar2(50). Now I want to search "Dept." column in all the tables, and if I find this column, I need to get its data type and verify if it matches with varchar2(50).
This is a small case with 10 tables.
Hope I have put my requirement clearly.
I can do it manually but want to automate the scenario. Will any tool/api help in such kind of scenarios?
Please let me know how I can go about testing such kind of scenarios. Any help/suggestions in this regard will be highly appreciated.