如何更改SQL Server表的列长度 [英] How can I change length of a collumn of SQL Server table

问题描述

你能帮我吗?

我有一个名为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表的列长度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！