Personal tools
You are here: Home → DB2 → How To's → How to know when an "CREATE TABLE" statement was last executed
Navigation
Log in


Forgot your password?
 
Document Actions

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>'"

 

 
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls