Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    51

    Unanswered: table creation date?

    Does informix keep track (somewhere) of when a table is created, like a time stamp for auditing,etc...?
    When in doubt just ask your self,
    -WWSBD?-
    (what would Sponge Bob do?)

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: table creation date?

    Originally posted by dnix
    Does informix keep track (somewhere) of when a table is created, like a time stamp for auditing,etc...?
    Hi there,

    Yes informix keeps track of all tables created in sysmaster database.
    You can run the below query
    select * from systables where tabid>99

    Regards,

    lloyd

  3. #3
    Join Date
    Sep 2003
    Posts
    10

    thanks!

    thanks for the info!
    Karma...it works regarless of your belief in it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •