Browse by Tags

All Tags » sql server » databases » change (RSS)
TSQL to generate a script that updates a column on every table in my database. How do I do this?
Published 29 July 7 3:39 AM | SSQA.net
SELECT 'ALTER TABLE ' + sysobjects.name + ' ' + 'ALTER COLUMN ' + syscolumns.name + ' ' + systypes.name + '(' + cast(syscolumns.length as varchar) + ') ' + 'COLLATE ' + syscolumns.collation + '...
Filed under: , , , ,