Thursday 12 March 2015

Rename column name in sql server











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_BookTypeIDCOLUMN is the object -type I need to change.