How to find out the table create date?

Database
Enthusiast

How to find out the table create date?

Please tell me how could I find out which tables or views recently created or changed? Is there a timestamp for it? Thanks!
3 REPLIES
Enthusiast

Re: How to find out the table create date?

Perhaps a query like this is what you want:

-- List all tables that have been created or altered within the last 10 days

select DatabaseName, TableName, LastAlterTimeStamp
from dbc.tables
where LastAlterTimeStamp > Current_TimeStamp - interval '10' day;
Enthusiast

Re: How to find out the table create date?

hope it would suffice to solve your prob....

select tablename, databasename, createtimestamp, lastaltertimestamp from dbc.tables where tablekind in ('T','V')
order by 4 desc
Enthusiast

Re: How to find out the table create date?

Thank you very much!