This little bit of SQL should help you determine who created a table or when it was created… <\/p>\n

SELECT \r\nCASE TAB.TYPE \r\nWHEN 'A' THEN 'Alias' \r\nWHEN 'N' THEN 'Nickname' \r\nWHEN 'S' THEN 'MQT' \r\nWHEN 'T' THEN 'Table' \r\nWHEN 'V' THEN 'View' \r\nELSE 'OTHER: '||TAB.TYPE \r\nEND AS T_TYPE \r\n,RTRIM(TAB.TABSCHEMA)||'.'||TAB.TABNAME AS TABLE_NAME \r\n,DATE(CREATE_TIME) AS CREATED \r\n,DATE(ALTER_TIME) AS ALTERED \r\n,TAB.COLCOUNT AS COLUMNS \r\n,TAB.DEFINER AS CREATED_BY \r\nFROM SYSCAT.TABLES TAB \r\nWHERE TABSCHEMA = 'XX' \r\nORDER BY TABLE_NAME \r\nFOR READ ONLY \r\nWITH UR;<\/pre>\n
<\/code><\/p>\nPlease remember to subscribe to the newsletter<\/a> to stay up to date!<\/i>\n\nYou or someone you know looking to buy or sell?<\/i>\n<\/a>\nDisclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...<\/small><\/i>","protected":false},"excerpt":{"rendered":"
This little bit of SQL should help you determine who created a table or when it was created… SELECT CASE TAB.TYPE WHEN ‘A’ THEN ‘Alias’ WHEN ‘N’ THEN ‘Nickname’ WHEN ‘S’ THEN ‘MQT’ WHEN ‘T’ THEN ‘Table’ WHEN ‘V’ THEN ‘View’ ELSE ‘OTHER: ‘||TAB.TYPE END AS T_TYPE ,RTRIM(TAB.TABSCHEMA)||’.’||TAB.TABNAME AS TABLE_NAME ,DATE(CREATE_TIME) AS CREATED ,DATE(ALTER_TIME) AS … Continue reading When Was a DB2 Table Created and by Who?<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false,"jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[3],"tags":[22],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2UXeD-8d","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/posts\/509"}],"collection":[{"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/comments?post=509"}],"version-history":[{"count":1,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/posts\/509\/revisions"}],"predecessor-version":[{"id":510,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/posts\/509\/revisions\/510"}],"wp:attachment":[{"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/media?parent=509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/categories?post=509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markjacobsen.net\/wp-json\/wp\/v2\/tags?post=509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}