How to alter data type for column

Question

I created this table but I forgot and set the data type for the price column  as nvarchar

Create table Product
(
 ID int primary key identity,
 ProductName nvarchar(50),
 Price nvarchar(50)
)

I want to alter datatype for column price from nvarchar to int  how can I do that?

Answer 1

Change data column type in SQL Server

To modify the data type of a column you can use two ways:

1) using SQL Server Management Studio

In object explorer - right click on Product table - click design
Select the column that you want to modify data type-change Price column data type from Nvarchar to int- and click save table

• In object explorer- right click on Product table - click design

• Modify data type-change Price column data type from Nvarchar to int- and click save

Note You can not Alter column from string to integer if the column holding string data

2) Using Alter Query

ALTER TABLE Product 
ALTER COLUMN Price int 

More information at change data type for column

Comments

What if the current column already hold string and you want to change it to int! Is it working??

---

If the column already hold string you will get  this error
Conversion failed when converting the nvarchar value  to data type int.
I update my answer now thanks for your comment