title: how to set maximum length to int data type in sql
body: <pre><code>ALTER TABLE table_name ALTER COLUMN column_name [int] (4)  NULL;
  </code></pre>
  <p>unable to execute the script, please assist how can I add maximum length to already existed column for an int data type.</p>
  <p><a href="https://i.stack.imgur.com/LUfJM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LUfJM.png" alt="enter image description here" /></a></p>