How to find all database references

Question :

How to find all database references,

Answer :

In trying to figure out (which is still unsolved and I still have no clue what is going on), I am wondering if maybe an external reference to the table in question is causing the problem. For example, a trigger or view or some other such thing.

Is there an easy way to find all references to a given database table? Including all views, triggers, constraints, or anything at all, preferably from the command line, and also preferably without a 3rd party tool (we are using db2).

Read More  Plain text passwords in Ruby on Rails using Restful_Authentication

,

Wow, I wouldn’t have thought it, but there seems to be.. Good ole DB2.

I find the publib db2 docs view very very handy by the way:

 

I just found the “SYSCAT.TABDEP” catalog view in it, which seems to contain more or less what you asked for. I suspect for anything not covered there you’ll have to trawl through the rest of the syscat tables which are vast. (Unfortunately I can’t seem to link you to the exact page on SYSCAT.TABDEP itself, the search facility should lead you to it fairly easily though).

Read More  Can cout alter variables somehow?

Most databases these days have a set of tables which contain data about the layout of your actual schema tables, quite handy for this sort of thing.

That’s the answer How to find all database references, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.

Disclaimer :

The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you

Read More  Favourite performance tuning tricks