In ORACLE we have a view called "cols", it can be used to ascertain which table contain a given column:
SELECT table_name, column_name
FROM cols
WHERE table_name LIKE 'RECEIVE%'
AND columns_name LIKE '%amount%';
This will find all tables which begin with RECEIVE and contains columns name containing the word amount in its name.
No comments:
Post a Comment