Overblog Follow this blog
Edit post Administration Create my blog
Balavardhan Reddy Narani

Alter Column Name of the Table by Query in SqlServer

March 12 2009 , Written by Balavardhan Reddy Published on #SQL Server2005

Changing the Column Name of the Table

Sqlserver has built in Stored Procedure sp_rename to change the column names of the Tables

EXEC sp_rename
@objname = '< Table Name.Old Column Name >',
@newname = '<New Column Name>',
@objtype = 'COLUMN'

Share this post

Repost 0

Comment on this post