DB2 Query to retrieve all table names for a given schema

by 
--for DB2/z
    select * from sysibm.systables
    where owner="SCHEMA"
    and name like '%CUR%'
    and type="T";

--for DB2/LUW
    select * from sysibm.systables
    where CREATOR = 'SCHEMA'
    and name like '%CUR%'
    and type="T";

This will give you all the tables with CUR in them in the SCHEMA schema.

See here for more details on the SYSIBM.SYSTABLES table. If you have a look at the navigation pane on the left, you can get all sorts of wonderful DB2 metatdata.

Note that this link is for the mainframe DB2/z. DB2/LUW (the Linux/UNIX/Windows one) has slightly different columns, as per the second query above.

You should examine the IBM docs for your specific variant if you’re using neither of those.

More Related Contents:

  1. DB2 Comma Separated Output by Groups
  2. What mysql database tables and relationships would support a Q&A survey with conditional questions? [closed]
  3. Does DB2 have an “insert or update” statement?
  4. how to transform comma separated column into multiples rows in db2
  5. INNER JOIN in UPDATE sql for DB2
  6. Pivoting in DB2
  7. Regular Expressions in DB2 SQL
  8. How to find column names for all tables in all databases in SQL Server
  9. How to resolve SQL0418N Error
  10. Designing a SQL schema for a combination of many-to-many relationship (variations of products)
  11. How to check db2 version
  12. How to concatenate text from multiple rows into a single text string in SQL Server
  13. Upserting in MS-access
  14. How do you list the primary key of a SQL Server table?
  15. Calculating distance between two points (Latitude, Longitude)
  16. What is atomicity in dbms
  17. Pivoting rows into columns dynamically in Oracle
  18. Detect consecutive dates ranges using SQL
  19. Scope of temporary tables in SQL Server
  20. Convert text value in SQL Server from UTF8 to ISO 8859-1
  21. How do I select all the columns from a table, plus additional columns like ROWNUM?
  22. Select a Column in SQL not in Group By
  23. How to do an inner join on row number in sql server
  24. SQL Server 2005 ROW_NUMBER() without ORDER BY
  25. How can I use my sql knowledge with Cloudant/CouchDB?
  26. Can an INNER JOIN offer better performance than EXISTS
  27. Is it possible to query a comma separated column for a specific value?
  28. incomplete information from query on pg_views [duplicate]
  29. How to create a pivot query in sql server without aggregate function
  30. IN vs. JOIN with large rowsets

Leave a Comment