Using DB2 catalog tables on OS/390

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 107 returns a list of tables from DB2 OS/390 with columns TABLETYPE (T indicates a table, V indicates a view), TNAME (table name), TABLE SPACENAME, and REMARKS.

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.