SQL query for alter column name

 table name: dbo.OrderPaperBooks

old column name : PPNoOfCopy

assign new column name :NoOfCopy 

SQL query for alter column name 

 EXEC sp_rename 'dbo.OrderPaperBooks.PPNoOfCopy', 'NoOfCopy', 'COLUMN';