you can also use the metadata to generate the statements you need to run...potentially 300 commands you said.
you did not provide any specific details, so here's a scenario to use as a model.
the column "CRDT" exists in a zillion tables in the database.
the description is really crappy, so we are renaming the column in every table to ''CREATED_DATE'' so it is more descriptive.
here's a code example to generate all those commands, which can be examined and run seperately:
select
'EXEC sp_rename ''' + QUOTENAME(sc.name) + '.' + QUOTENAME(tb.name) + '.' + QUOTENAME(col.name) + ''', ''CREATED_DATE'', ''COLUMN'' ' AS SQLCMD,
sc.name,tb.name,col.name
from sys.tables tb
inner join sys.schemas sc on tb.schema_id = sc.schema_id
inner join sys.columns col on tb.object_id = col.object_id
where col.name = 'CRDT'
Lowell