How to update DB Column

Using below query all table's having Createdby and Updatedby column should be altered. You don't need to fire query for each table.

SELECT
'ALTER TABLE ' + TABLE_NAME
+ ' ALTER COLUMN Createdby varchar(50) go ' AS Createdby, 'ALTER TABLE ' + TABLE_NAME
+ ' ALTER COLUMN Updatedby varchar(50) go ' AS Updatedby  + ';'
FROM INFORMATION_SCHEMA.TABLES

Read More