title: How to change all column name to UPPER CASE for all the tables in one database of MS SQL Server?
body: <p>is there any sql statement used to change all column name to UPPER CASE for all tables in database? MS SQL Server. </p>
  
  <p>I got a sql to do that, but not sure whether it`s correct.</p>
  
  <ol>
  <li><p>run SQL below</p>
  
  <pre><code>select 'exec sp_rename '''+b.name+'.'+a.name+''','''+UPPER(a.name)+''',''column'''
  from syscolumns a, sysobjects b 
  where a.id=b.id and b.type='U' 
  order by b.name
  </code></pre></li>
  <li><p>copy and execute the result above </p></li>
  </ol>