A SQL parsing engine to list SQL objects used in the statements?

lfagetti

Hi, I'd like to know if there is any future plan to provide a more generic engine capable to perform same and more functionalities of those in SQL Prompt.
Briefly, you pass one or more objects (stored procedure/function/view or just a SQL statement), a profile of rules and settings, and you get back a list of all objects being used (and how) by each object plus all the relevant info/warning/errors.

I see SQL prompt powered by something not far from this...

Thanks 

Jessica R

Hi @lfagetti, 

Thanks for your post!

Our developers are actually looking into the possibility of an option for applying code analysis to an entire database, as well as the ability to apply it via command line. I think that's somewhat along the lines of what you're hoping for, but I've passed some feedback to our developers that being able to pass in specific objects would be particularly helpful- thanks for this! Please keep an eye on our road map here for updates: https://www.red-gate.com/products/sql-development/sql-prompt/roadmap

There aren't any plans at the moment though for listing all objects used - could you please create a request for this one on our uservoice forums: https://redgate.uservoice.com/forums/94413-sql-prompt 

(It might be worth mentioning though that we have a tool called SQL Dependency Tracker https://www.red-gate.com/products/sql-development/sql-dependency-tracker/index that allows you to analyze database object dependencies which you might find helpful)

lfagetti

Thank you Jessica, SQL dependency Tracker could be useful, but only partially when more and more queries are coming in-line by frameworks and not longer embedded in StoredProcedures 
I will set the request thru the link you provided.
Happy weekend!

Jessica R

Ah I see, it would be good to have the request then- thank you!

Happy weekend to you as well.