You have to include the datatype and the collation name. Here's an example:

ALTER TABLE Table1
ALTER COLUMN Col1 varchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS

Roman

>Hello,
>
>I have to do some maintenance on a SQL 2000 database. I have to build a script to alter some tables in this database. I found out that collation is set on some fields in some tables. I want to reset collation of these fields to the default, but I can't get it right. I tried these variants of Alter Table:
>
>

>Alter Table <tablename> Alter Column <fieldname> Collate
>Alter Table <tablename> Alter Column <fieldname> Collate ''
>Alter Table <tablename> Alter Column <fieldname> Collate ' '
>Alter Table <tablename> Alter Column <fieldname> Collate []
>Alter Table <tablename> Alter Column <fieldname> Collate [ ]
>

>
>None of these statements work.
>Has anyone an idea how to reset the collation?
>
>TIA,
>
>Martin