To change the data type of a column without dropping the table (SQL Server 2008):

SQL

ALTER TABLE [dbo].[tbl_001] ALTER COLUMN clm_001 nvarchar(50)