title: How to update column_name in information_schema.columns
body: <p>Unable to update the column_name column in information_schema.columns</p>
  
  <p>I have a table named 'knd' in MS-SQL server. Now I want to alter the column names of all the columns in this table in this way:</p>
  
  <p>for example, my column names in this table are: Fuel category, fuel type, end date, start date</p>
  
  <p>I want to update these names to [Fuel category], [fuel type], [end date], [start date]. i.e column names must include [] and the updation should be done in one shot.</p>
  
  <p>What I have tried:</p>
  
  <pre><code>update INFORMATION_SCHEMA.COLUMNS
  Set COLUMN_NAME = CONCAT('[',COLUMN_NAME,']')
  where TABLE_NAME = 'knd'
  </code></pre>
  
  <p>I get the below error:</p>
  
  <p>Ad hoc updates to system catalogs are not allowed.</p>
  
  <p>I tried to reconfigure with override as below, but didn't work:</p>
  
  <pre><code>exec sp_configure 'allow updates','1';
  go
  reconfigure with override
  go
  </code></pre>
  
  <p>even if I have to use exec sp_rename, how can I do it for all columns in one shot. I believe using sp_rename requires more manual intervention as my column names might change tommorow .</p>
  
  <p>Can someone please help to accomplish this?</p>