By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

how to know how many tables i created in the database

P: n/a
how to know about how many tables i created in that database.if the
database is connected to many users.

i want the query in this way that i want creater,number of
tables,time,updates .

the last two columns not required i need the number of tables i created
in that table

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Connect to your DB.
Short way: db2 list tables for USER
db2 list tables for schema <schemaname>
Or:
select tabschema,tabname,definer,create_time from syscat.tables where
tabschema=USER

Updates are not kept in those catalog tables. You'd have to creatr an event
monitor or take regular snapshot to get those numbers.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"narayana" <va***********@gmail.com> a écrit dans le message de news:
11**********************@g49g2000cwa.googlegroups. com...
how to know about how many tables i created in that database.if the
database is connected to many users.

i want the query in this way that i want creater,number of
tables,time,updates .

the last two columns not required i need the number of tables i created
in that table


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.