Modify the field type and name segment name in SQL Server statements

SQL statement for sqlServer to modify the field type and rename the field name altertablevkesoftaltercolumnUser_namenvarchar (50) Rename the field name (vkesoft is the table name and UserName is the original column name, user_Name is the new column name) EXECsp_renamevkesoft

SQL statement for modifying Field Types and renaming field names in sqlServer // alter table vkesoft alter column User_name nvarchar (50) // rename the field name (vkesoft is the table name, userName is the original column name, And User_Name is the new column name) EXEC sp_rename 'vkesoft

SqlServerModifyFieldTypeAnd renameFieldNameSQLStatement
//ModifyFieldOfType

alter table vkesoft alter column User_name nvarchar(50)

// RenameFieldOfName(Vkesoft is the table name, UserName is the original column name, And User_Name is the new column name)

EXEC sp_rename 'vkesoft.UsersName','User_Name','column'

// AddField

alter table vkesoft add User_Name nvarchar(50)

// DeleteField

alter table vkesoft drop User_Name nvarchar(50)