Link to home
Start Free TrialLog in
Avatar of Matthew Roessner
Matthew Roessner

asked on

iSeries DB2 Query

Is there a query to run in DB2 (or a command to run that would accomplish the same thing) that will show me all tables with an owner of "username".

I know in Oracle - we would run the following command:

SELECT table_name FROM all_tables where owner='myusername'

Thank you in advance
ASKER CERTIFIED SOLUTION
Avatar of Member_2_2484401
Member_2_2484401
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Matthew Roessner
Matthew Roessner

ASKER

Thanks for your help!