Hi,
Sql server provide a procedure to do this function is
SP_RENAME.
And the code right here,
SP_RENAME 'Book.BookType','FK_BookTypeID','COLUMN';
Here : Book is my table name,having field BookType. Here I have to rename the field to FK_BookTypeID. COLUMN is the object -type I need to change.