Here are some DB2 queries that can be very useful. 5 Useful Queries In DB2 Query to identify Stores Procedures using a particular table View the code on Gist. Identify Schema used by Stored Procedures View the code on Gist. Identify Primary Key of a table View the code on Gist. Identify Foreign key of a table View the code on Gist. View used by table View the code on Gist.