Re: create_time

2015-05-01 Thread Pothanaboyina Trimurthy
If you run any DDL (add column, drop column etc..) commands against particular table then create_time will update to the latest time when the DDL performed. If you run any DML statements (insert,update,delete), then update_time colum's value chages, If you restart the DB instance then update_time

Re: create_time

2015-05-01 Thread Martin Mueller
That’s not quite an answer to the question I asked. Does “create_time” represent the date at which a table was created, and does that date change or stay the same if there is an update on the table or columns are removed or added? I had an experience where a table that I knew to be several m