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:
'EXEC sp_rename ''' + QUOTENAME(sc.name) + '.' + QUOTENAME(tb.name) + '.' + QUOTENAME(col.name) + ''', ''CREATED_DATE'', ''COLUMN'' ' AS SQLCMD,
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'
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!