(5.6)
drop table tab1;
create table tab1(col1 int);
select table_schema,table_name,create_time,update_time
from information_schema.tables
where table_name = 'tab1'
;
alter table tab1 add col2 int;
select table_schema,table_name,create_time,update_time
from information_schema.tables
where table_name = 'tab1'
;
create_timeはテーブル更新日
update_timeは常ににNULL
テーブル作成日は取得できない模様
(12cR1)
alter session set nls_date_format='YYYY/MM/DD HH24:MI:SS';
drop table tab1 purge;
create table tab1(col1 int);
select owner,object_name,created,last_ddl_time
from dba_objects
where object_name = 'TAB1'
;
alter table tab1 add (col2 int);
select owner,object_name,created,last_ddl_time
from dba_objects
where object_name = 'TAB1'
;
(9.4)
テーブル作成日と更新日のいずれも取得できない模様
(2014)
drop table tab1;
create table tab1(col1 int);
select schema_name(schema_id) schema_name,name,create_date,modify_date
from sys.objects
where name = 'tab1'
;
alter table tab1 add col2 int;
select schema_name(schema_id) schema_name,name,create_date,modify_date
from sys.objects
where name = 'tab1'
;
