I realize this is new post to an old post, but when you are looking for solutions, it would be nice to see one that works simply.
I believe the simple solution to this problem is the stored procedure called:
sp_rename
to quickly rename a file with script do the following:
sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name'
[ , [ @objtype = ] 'object_type' ]
USE AdventureWorks;
GO
EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';
GO
You can find more detailed info in books on-line. This works with MSSQL 2000 and 2005.
____________________
Keep it simple!
|