cancel
Showing results for 
Search instead for 
Did you mean: 

date my table was created

former_member205400
Active Participant
0 Kudos

Hi Experts,

I'm looking in my Q system to see some dates where my tables in my specific schema were created.

I'm thinking there should be some table that shows that kinda of data.

If I exe this sql:

SELECT *

FROM "SYS"."M_TABLES"

WHERE SCHEMA_NAME = 'my_schema'

I can see the number of rows in the table but it does not have the date the table was created or activated.

Maybe it is in a table that stored data related to imports as it was imported.

Mike

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Mike,

Have you had a look at view SYS.M_CS_TABLES? There is a CREATE_TIME column in this view that will have created timestamp.

Thanks,

Anooj

former_member205400
Active Participant
0 Kudos

btw ... is there a metadata table related to when objects were imported?

For tables we can see the create and modify times .... but i'm also interested in my package imports and when they went in and the objects in those packages.

Mike

Answers (0)