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
206 views
No Comment
(No Ratings Yet)
Loading ...SELECT * FROM SYSTABLES WHERE OWNER=
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?
- In which column of which DB2 catalog would you find the length of rows for all tables?
- Once you create a view, where would information about the view be stored?
- Write query to get custom results
Leave your response!
You must be logged in to post a comment.