Change (Modify) Column name of table in SQL Server

Last Reply 7 months ago By dharmendr

Posted 7 months ago

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?