Built a table in the
database , but because of the
SQL Server table function is not familiar with, do not know what to set the primary key to what is good, first set a text type, but later friends told me that the text type easy to make the data file becomes very large, but also It's better to change to an int type. You are about to modify the field type. But always prompt not to let me change, that means you can only rebuild the table. Access can let casually modify the type, why SQL Server does not, do not believe this evil, or to ask the professional test SQL Server personnel, asked for a long time no response, it seems to have to go to Baidu, this search is very smooth, directly found a contented answer.
This is the default setting for SQL Server itself, which defaults to a type that cannot be modified. All you need to do is "Tool->option->designer
Table and Database designers remove prvent saving changes that require table re-created. " Yes, it did, and it worked.
After you modify the data type of a field in a table in a SQL Server database, you cannot save