更改SQL表中的列名 [英] Change Column name in sql table

问题描述

我在sql中有一个表.我必须使用查询更改字段名称.

I have a table in sql. i have to change name of a field using query.
what will be query for that.

推荐答案

sp_rename [^ ]

EDIT

---

如果要更改结果集中的列名，则可以使用如下别名.

sp_rename[^]

EDIT

---

If you want to change the column name in result set then you may use alias like as below.

SELECT ID AS EmpID, [Name] AS EmpName FROM EMP

尝试sp_rename:

http://blog .sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/ [

try sp_rename :

http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/[^]

Hope it helps.

也请同时参考此网站

http://www.w3schools.com/sql/sql_alter.asp

refer this site as well

http://www.w3schools.com/sql/sql_alter.asp

这篇关于更改SQL表中的列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！