Wednesday, August 27, 2008

change column name of sql table

EXEC sp_rename
@objname = 'TableName.FieldName',
@newname = 'NewFieldName',
@objtype = 'COLUMN'

No comments: