I have table employee:

Empid(Primary key)

empname

address

Country

I wanted to change the name of the column From Country to State. How to modify the column name in sql server?

I know that this is a very basic question.The only thinng which i know is that right click on Country-->RENAME-->CHANGE THE NAME...

Is It the way?