IBM DB2 List of Tables Inside Db Schema

on


$ db2 "SELECT TABSCHEMA, TABNAME, CREATE_TIME, ALTER_TIME, INVALIDATE_TIME, COLCOUNT, TABLEID, TABLESIZE FROM SYSCAT.TABLES WHERE UPPER(TABSCHEMA) = UPPER('APPCORE') ORDER BY TABNAME ASC"

Comments

Post a Comment