Changing column name using DBCC statement

Posted by Sanyok under Sql Server on 3/23/2010 | Views : 3299 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hello all

Is there any way to change the column name of Table(Table1) using DBCC statement only ?

Table name : Table1
Column Name : SerialNo

The column name has to be changed to Slno.

waiting for perfect answer.

thanks in advance
Sanyok K

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Pandians on: 3/23/2010 [Member] [MVP] Silver

0	Hi Sanyok Greetings YES. You can use a DBCC statement : DBCC RenameColumn. But this is Un-Documented, You can simply use SP_Rename instead. Syntax: DBCC RenameColumn (TableName,ExistingColumnName,NewColumnName) ie: DBCC RenameColumn (Table1,SerialNo,Slno) Cheers Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Sanyok, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Sanyok

Greetings

YES. You can use a DBCC statement : DBCC RenameColumn. But this is Un-Documented, You can simply use SP_Rename instead.

Syntax:

DBCC RenameColumn (TableName,ExistingColumnName,NewColumnName)

ie:

DBCC RenameColumn (Table1,SerialNo,Slno)

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Sanyok, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts