The simplest and most straightforward way to modify the creation time of a SQL Server database table

Description: This article is a few years ago I published in the NetEase blog original article, but because NetEase blog now to stop operation, so I put this article moved over, because this way of operation is universal, even to the latest SQL Server database inside the operation is the same, I believe many friends will use it.

—————————————————————— Split Line ————————————————————

There have been many people on the network to ask how to modify the SQL Server database table creation time, but the answers are various, some say that need to use some software to modify, some say that need to modify the registry, etc., in fact, these methods are not only cumbersome to implement, and many times it is useless.

The following is a summary of my method, very simple, and through the SQL Server 2000 and SQL Server 2005 modification Test, absolutely effective! In a nutshell, it is possible to modify the data type (or field size) of any of the fields in the table. The following is an example of SQL Server 2005 to illustrate the process of its modification.  ① in version 2005 of SQL Management Studio (Enterprise Manager version 2000), open the section of the database table you want to modify (the Red Circled section of the figure indicates the time the table was created before the modification):

② Right-click on the table you want to modify, select "Modify" (note: These operations are slightly different in the SQL Server 2000 version, the following are not described below):

③ Modify the data type of any field in the table (or modify the field size directly, modify the column name to be invalid):

Modification Principle:1, as far as possible to modify the data type character (char) type of field, because these fields are relatively strong compatibility, and more derived types (such as Char,varchar,nvarchar,nchar, etc. can be common), try not to modify such as Float,int, Iamge and other types of fields, because these types of fields are special, then modify the later still need to change back, trouble. 2, usually the field size is small to large changes, because the field large can accommodate the field of small fields, this is very easy to understand.  ④ Modify and close the current form and save it:

⑤ Right-click in the space, select "Refresh", and of course you can turn off SQL Management Studio and reopen it:

⑥ so that the creation time of the table has been modified:

Note: All the articles in this blog are original, welcome reprint, but please indicate the words "Raven Software" when reproduced, thank you!

The simplest and most straightforward way to modify the creation time of a SQL Server database table