title: How to alter a column's attribute using sql script
body: <p>How can I alter a column's attribute using a sql script?</p>
  
  <p>Here's what I've tried but I got errors:</p>
  
  <pre><code>ALTER TABLE [dbo].[tblBiometricPattern] COLUMN BiometricPatternID TINYINT NOT NULL IDENTITY(1,1)
  </code></pre>
  
  <p>Thank you in advance.</p>
  
  <p>Here's the error message that appears when executed:</p>
  
  <pre><code>Incorrect syntax near the keyword 'COLUMN'.
  </code></pre>