How can we improve SQL Prompt?

Find Invalid Objects - exclusions

I would like to set exclusion rules in the 'Find Invalid Objects' tool so that I don't see hundreds of invalid objects that I know are fine.

Specifically, I want to exclude references to missing objects called '%tmp%', but I imagine there are probably other exclusion rules that would be useful.

4 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrew Hartley shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Peter Scurr commented  ·   ·  Flag as inappropriate

        I like this idea. We have a schema created where we move obsolete objects to, for a period of time in case they are need back in a hurry and then get fixed.
        We use the same schema to put objects that we expect are unused.
        I'd like to be able to configure the invalid Objects to exclude an entire schema.

      Feedback and Knowledge Base