Wednesday, 29 August 2018

DB2 - List all the tables


list tables

or

db2 "select tabname,owner from syscat.tables"

or

db2 "select name,creator from sysibm.systables where name like '%anyStringInTableName%'"
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)