Wednesday, March 7, 2012

I need to change the name of a field...

I need to change the name of a field in a db hoy can I do soUSE <db name>
GO
EXEC sp_rename '<table name>.[org. field name]', '<new field name>', 'COLUMN'
GO

No comments:

Post a Comment