Change column collations back to database default

SELECT 'ALTER TABLE ['+USER_NAME(o.uid)+'].['+o.[name]+'] ALTER COLUMN ['+c.[name]+'] '+
	CASE
		WHEN c.prec IS NULL THEN t.[name]
		ELSE t.[name]+'('+CONVERT(varchar(5),c.prec)+')'
	END+' COLLATE '+t.collation
FROM syscolumns c
	JOIN sysobjects o ON (c.id = o.id)
	JOIN systypes t ON (c.xusertype = t.xusertype)
WHERE c.collation IS NOT NULL
	AND o.type = 'U' -- NOT IN ('P','FN','TF','IF','S','V')
	AND c.collation <> t.collation
ORDER BY o.[name]