I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
9 August 2009
115 views
No Comment
(No Ratings Yet)
Loading ...The query SELECT * FROM SYSIBM.SYSTABLES WHERE CREATOR = ‘owner id’ This displays the table names with that If you want only the number of tables give the following query. SELECT COUNT(*) FROM SYSIBM.SYSTABLES WHERE CREATOR = ‘owner id’ Make sure that you are in correct subsystem.
Popularity: unranked [?]
Related interview questions
- I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
- I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
- Once you create a view, where would information about the view be stored?
- In which column of which DB2 catalog would you find the length of rows for all tables?
- What is a view?
Leave your response!
You must be logged in to post a comment.