DB2 graphic  QMF Version 8

Using DB2 catalog tables on z/OS

Note: Certain tables in the system catalog have columns containing binary data. Such columns have character data types but do not contain character data. Retrieving data from these columns can cause an incoherent display, because some of the column "characters" can give unexpected signals to the screen manager.

Listing tables and views

The query in Figure 38 returns a list of tables from DB2 UDB for z/OS with columns TABLETYPE (T indicates a table, V indicates a view), TNAME (table name), TABLE SPACENAME, and REMARKS.

Figure 38. Listing DB2 tables and views owned by a particular user (OS/390)
SELECT TABLETYPE, TNAME, TABLE SPACE NAME, REMARKS
  FROM SYSIBM.SYSTABLES
  WHERE CREATOR = 'userid'
  ORDER BY TABLETYPE, TNAME

Deleting a table or view from the database

Use the SQL DROP TABLE statement or the QMF ERASE command to delete tables or views from the database. Only the creator of the table or someone with DBA authority can delete it.

When you delete the row of the SYSIBM.SYSTABLES table that defines the table, all views, synonyms, and indexes associated with the table are also deleted. Before you drop a table from the database, ensure that no other user relies on it (for example, for command synonym or function key definitions).

For more information on erasing tables, see the appropriate DB2 UDB Administration Guide.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004