get last added column on which table

  • how can i get the table name of newly added column in sql server 2005

  • How can one add the column without knowing the table name.

    Anyway,you can query the syscolumns system table order by Created_date desc.Get the object_id from this and query the sysobjects table to get the table name.

Viewing 2 posts - 1 through 1 (of 1 total)

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