search

Google
 

Tuesday, February 5, 2008

How to Alter a column DataType in SQL Server 2005

USING [Database_Name]
ALTER TABLE [Table_Name]
ALTER COLUMN [ Field_Name] New_Datatype

Example :-

ALTER TABLE myTable
ALTER COLUMN fieldname nvarchar(255)

No comments: