|
View previous topic :: View next topic
|
| Author |
Message |
l.nethaji
New User
Joined: 16 Mar 2008
Posts: 90
Location: tamil nadu
|
|
|
|
Can anybody tell me how to find the no of tables in a database .
Is ther any system table where we can find the total no of tables .
Please give the query for the same ,
Similarly how to find it in PLATINUM tool the no of tables . |
|
| Back to top |
|
 |
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| The number of tables in a given data base can be ascertained by getting the count of rows on SYSTABLES with that data base name and a type of "T(able)". Likewise, the total number of tables on a given DB2 subsystem will be the number of rows on SYSTABLES with a type of "T". As you purport to be a software engineer with a knowledge of DB2, I have every confidence that asking for me to write so trivial a query is mere sloth on your part. |
|
| Back to top |
|
|
l.nethaji
New User
Joined: 16 Mar 2008
Posts: 90
Location: tamil nadu
|
|
|
|
Hi,
Thanks for the reply
Regards,
L.Nethaji |
|
| Back to top |
|
|
|
|
