Results 1 to 2 of 2

Thread: Is it possible to find out when a particular column was added to a table?

  1. 11-04-2005, 05:42 PM #1
    DBFan
    DBFan is offline Registered User
    Join Date
    Aug 2004
    Location
    USA
    Posts
    80

    Is it possible to find out when a particular column was added to a table?

    Is it possible to find out when a particular column was added to any table?

    Thanks
    Reply With Quote Reply With Quote
  2. 11-04-2005, 06:54 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    SQL Server only captures create date for a table, after that no date is captured for alters.

    Oracle captures createdate and last ddl time but it could be any DDL.

    So the answer is no. But log explorer or log miner can dig such information.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules