Tuesday, 1 July 2014

How to know when an "CREATE TABLE" statement was last executed

How to know when an "CREATE TABLE" statement was last executed

from syscat.tables using the column CREATE_TIME
Perform the select below to find out when a table was created

db2 "select substr(tabname,1,20) as TABLE, create_time from syscat.tables
 where tabname='<table_name>'"

No comments:

Post a Comment