更新时间:2023-11-22 23:11:10
否.
sp_RENAME 'myTable.[myColumn]' , '[myNewColumnName]', 'COLUMN'
不,您不会丢失任何现有数据.
使用以下查询更新列名称
ALTER TABLE<您的表名>
重命名列[EmployeeName] TO [EmployeeFullName]
阿比吉特(Abhijit)
No, you will not lose any existing data.
Use following query to update column name
ALTER TABLE <your_table_name>
RENAME COLUMN [EmployeeName] TO [EmployeeFullName]
Abhijit