Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to find when a Table was created

Status
Not open for further replies.
naveenrt

naveenrt

Technical User
Mar 23, 2001
53
US
Hi,
Is there any command in DB2 to find What was the timestamp and date a table was created initially

Thanks
Naveen
 
Sort by date Sort by votes
You have to query the system catalog tables:
i.e "select tabname, create_time from syscat.tables where tabname = 'TABLENAME'".... this will give you the the date and time the table was created
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Conditionally have a subfile display record blink
Replies
5
Views
395
mikrom
mikrom
C
  • Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
254
chuckw0325
C
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
292
tekpr00
tekpr00
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
201
evr72
evr72
ColeFern
  • Locked
  • Question
SQL1224N A database agent could not be started to service a request, or was terminated as a result
Replies
0
Views
211
ColeFern
ColeFern

Part and Inventory Search

Sponsor

Back
Top