Are any of the tools mentioned in these comments better suited to searching SQL code, both DML and DDL?
We maintain a tree of files with each object in a separate "CREATE TABLE|VIEW|PROCEDURE|FUNCTION" script. This supports code search with grep, but something that could find references to an object when the name qualifications are not uniform would be very useful:
INSERT INTO table
INSERT INTO schema.table
INSERT INTO database.schema.table
Can all be done with regex, but search is not so easy for programmers new to expressions.
We maintain a tree of files with each object in a separate "CREATE TABLE|VIEW|PROCEDURE|FUNCTION" script. This supports code search with grep, but something that could find references to an object when the name qualifications are not uniform would be very useful:
INSERT INTO table INSERT INTO schema.table INSERT INTO database.schema.table
Can all be done with regex, but search is not so easy for programmers new to expressions.