| Next Tip?
Home » DB2

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
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... 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 [?]

Post to Twitter Tweet This Post

Related interview questions

Leave your response!

You must be logged in to post a comment.

Get Adobe Flash playerPlugin by wpburn.com wordpress themes