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?