想要移动已建立的表的字段顺序,
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