I need to know how to rename a SQL table column from any name. I can use the following code if I know the current name.

```
    sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

```

But if I don't know the column name, how can I change it to a new one? Thanks in advance.