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
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729