• 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


    --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!