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'
Wednesday, December 31, 2008
Rename Column in SQL Server
Labels:
SQL Server,
SQL Server Tips,
Vijaya Kadiyala
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment