Post reply

Table Create Date issue?

  • August 27, 2020 at 6:02 pm

    #3784201

    I'm running SQL Server 19.  Is there a known issues with the table create date?  (search didn't yield anything)  The Create and Modify date are taken from sys.all.objects.

    I created a database on July 17th and created most of the tables on the same date.

    Now looking at the Create Date (as part of a database documentation exercise) I see that in some instances the Create Date is close to a Modified Date of another table (DDColumnObject and DDDataType)  DDDataType Create Date is correct.  A column would have been added to DDColumnObject on Aug 24th (an FK to DDDataType).

    DDErrorLog was created on July 17th (not August as shown) and modified on Aug 24th.

    SQL Create Date

    Thanks for any assistance

  • August 27, 2020 at 6:21 pm

    #3784203

    No.

    How were DDColumnObject and DDErrorLog modified?  via SSMS GUI? Or with TSQL alter table statements?

    If you used the GUI, it may have re-created the tables rather than simply altering.

  • August 27, 2020 at 6:28 pm

    #3784205

    All tables would have been modified with SSMS GUI.

    DDIndexColumn was also been modified with the GUI yet has the correct Create Date.

  • August 27, 2020 at 6:49 pm

    #3784215

    tnpich wrote:

    All tables would have been modified with SSMS GUI.

    DDIndexColumn was also been modified with the GUI yet has the correct Create Date.

    This will depend on what changes were made - there are some (very few) changes where SSMS can identify that an ALTER is all that is needed.  In most cases, SSMS GUI will create a new table - copy the data from the old table into the new table - drop the old table - rename the new table to the old table name.

    You can validate this by generating the script when making changes which will show you how SSMS is going to make the change.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • August 27, 2020 at 7:02 pm

    #3784223

    I'll have to play around with this to see when it occurs.

    I know with DDColumnObject, I deleted a column and added another one.

    In DDErrorLog, it was a column deleted

    I think that DDIndexColumn was several columns deleted

     

    Thanks all

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply