SELECT schemaname FROM syscat.schemata; select name, tbname, coltype from sysibm.syscolumns; select name from sysibm.systables; select tbname from sysibm.syscolumns where name=’username’