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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER