title: Renaming column which is designed as [col_name] in the database
body: <p>i had made a table with column:</p>
  
  <pre><code>[id_no]  int not null,
  name varchar(20).
  </code></pre>
  
  <p>Now when i am tying to rename the column [id_no] to id using query:</p>
  
  <pre><code>sp_RENAME 'tbl_cust.[id_no]','id,'COLUMN';
  </code></pre>
  
  <p>I gets an error message.The question is, can a column be renamed which starts with brackets[col].</p>