Creation date for tables

Hi,
This is my first time posting in this forum. I am very green in DB2 admin so I would really appreciate your help.
The company had a data warehouse on DB2 7.1 on a sun solaries 8
I want to know how to retreive creation date from any table
ThanksDid you mean to post this in the SQL forum?

Regards,

hmscott|||Right church, wrong pew...

no matter...do this against your database...it should show you the definition of your tables and columns

SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = 'your owner id'

And try here...


http://www.dbforums.com/f8/