Pages

Wednesday, December 31, 2008

Rename Column in SQL Server

The following sample code demonstrates how to rename a column in SQL server using the stored procedure

EXEC sp_rename @objname = '[TableName].OldColumnName',
@newname = 'NewColumnName',
@objtype = 'COLUMN'

No comments: