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]