Sunday, January 29, 2006

Changing the datatype of a Column

Changing the datatype of a Column:

"ALTER TABLE table ALTER COLUMN column_name new_data_type
Ex.
ALTER TABLE MyTable ALTER COLUMN MyColumn NVARCHAR(20)"
Post a Comment