移动表字段顺序，更改字段的属性

想要移动已建立的表的字段顺序，

If you want to modify a table property through the UI which requires a table recreation, then you need to change the following options in Management Studio:

Tools ->Options-> Designers -> Table and Database Designers -> uncheck the option "Prevent saving changes that require table re-creation"

想要更改字段的属性，变成int或者其他的，变成空或者非空，限制长度等，

ALTERTABLE mytable ALTER COLUMN name int NOT NULL