本文介绍了如何更改SQL Server表的列长度的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你能帮我吗?
我有一个名为Employee的表.我想更改列EmployeeNo(varchar(6))
到EmployeeNo(varchar(10)).
这意味着我想将大小从6更改为10.该表中有3000行.
请让我知道查询以更改大小.
在此先感谢,
Bulbul
Hi,
Could you please help me.
I have a Table named Employee. I want to change the column EmployeeNo(varchar(6))
to EmployeeNo(varchar(10)).
That means I want to change the size from 6 to 10. There is 3000 rows in that table.
Please let me know the query to change the size.
Thanks in Advance,
Bulbul
推荐答案
ALTER TABLE Employee
ALTER COLUMN EmployeeNo VARCHAR(10)
这篇关于如何更改SQL Server表的列长度的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!