DB2: object types

 

• SYSCAT.INDEXES for indexes.
• SYSCAT.TRIGGERS for triggers.
• SYSCAT.ROUTINES for stored procedures and functions.
• SYSCAT.TABLES for tables

SELECT TABNAME AS OBJECT_NAME, TABSCHEMA AS SCHEMA_NAME, TYPE AS OBJECT_TYPE FROM SYSCAT.TABLES WHERE TABNAME = 'YOUR_OBJECT_NAME';

SELECT *

FROM SYSCAT.tables where tabschema='WCS' order by tabname;

SELECT * FROM SYSCAT.ROUTINES where routineschema='WCS' order by routinename;

SELECT * FROM SYSCAT.INDEXES where INDschema='WCS' order by INDname;

SELECT * FROM SYSCAT.TRIGGERS where trigschema='WCS' order by trigname;