title: Azure SQL DB not updating varchar length
body: <p>I created a table using the following SQL command:</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE [my-azure-db].dbo.MyTable (
      Id int IDENTITY(1,1) NOT NULL,
      Name nvarchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  );
  </code></pre>
  <p>When I check the table with DBeaver, it looks like this:
  <a href="https://i.stack.imgur.com/YWk2W.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YWk2W.png" alt="DBeaver View" /></a></p>
  <p>Therefore, I tried to alter the table and change the size of the field with the following script.</p>
  <pre class="lang-sql prettyprint-override"><code>ALTER TABLE [my-azure-db].dbo.MyTable ALTER COLUMN Name nvarchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL;
  </code></pre>
  <p>The script runs through and the varchar size is still stuck at 16. When I try to do this directly in the Azure Query Editor, it also does nothing.</p>