DB2 system table resource

-- CHECK USER TABLES

SELECT NAME FROM SYSIBM.SYSTABLES WHERE CREATEDBY = CURRENT_SCHEMA

SELECT NAME FROM SYSIBM.SYSTABLES WHERE CREATEDBY = '<USERNAME>'

-- CHECK TABLE COLUMNS INFORMATION

SELECT NAME, COLTYPE, LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = 'EMPLOYEE' AND TBCREATOR = CURRENT_SCHEMA

-- CHECK SEQUENCES

SELECT NAME FROM SYSIBM.SYSSEQUENCES WHERE CREATEDBY = CURRENT_SCHEMA

-- CHECK TRIGGERS

SELECT NAME FROM SYSIBM.SYSTRIGGERS WHERE CREATEDBY = CURRENT_SCHEMA

-- CHECK PROCEDURE AND FUNCTION

SELECT NAME FROM SYSIBM.SYSROUTINES WHERE ROUTINETYPE = 'P' AND CREATEDBY = CURRENT_SCHEMA

SELECT NAME FROM SYSIBM.SYSROUTINES WHERE ROUTINETYPE = 'F' AND CREATEDBY = CURRENT_SCHEMA

-- CHECK INDEXES

SELECT NAME FROM SYSIBM.SYSINDEXES WHERE TBNAME = '<TABLENAME>'