Solved

When was column added to an MS SQL Server table

Posted on 2014-02-11
2
604 Views
Last Modified: 2014-05-16
Does MS SQL server keep a record somewhere of when a column has been added to a table?

Where would I find that information?

Thanks
0
Comment
Question by:Rossamino
2 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 445 total points
ID: 39851902
Unfortunately you can't, sql server does not store information on when a column was created in the sys.columns table.
0
 
LVL 3

Expert Comment

by:stevejacob68
ID: 40069537
Hi,
       
MS SQL SERVER does not provide any method to check the date and time of added column.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now