Question 105395 in Azure Question posted in
The official documentation to get you started can be found here.

Azure SQL DB not updating varchar length

I created a table using the following SQL command:

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,
);

When I check the table with DBeaver, it looks like this:
DBeaver View

Therefore, I tried to alter the table and change the size of the field with the following script.

ALTER TABLE [my-azure-db].dbo.MyTable ALTER COLUMN Name nvarchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL;

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.

Tags:

2

Answers


  1. 0

    enter image description here
    enter image description here

    CREATE TABLE dbo.MyTable
(
    Id int IDENTITY(1,1) NOT NULL,
    Name nvarchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
);

ALTER TABLE dbo.MyTable ALTER COLUMN Name nvarchar(16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL;
    Login or Signup to reply.
  2. 0

    I reproduced this in Azure SQL Database, and there is no change in the nvarchar size, and I am able to change it using query.

    I created the above table with the name of reprotable and this is my table description with nvarchar(32).

    The code for table description below is taken from this article of dataedo by Bart Gawrych.

    enter image description here

    You can see the max_length is 64 above which means it is nvarchar(32).

    Change to nvarchar(16) using your code.

    enter image description here

    Try to use [dbo].[tablename] and check the result as suggested by Courser Xu.

    And I suggest you try to create the table and Azure SQL DB and SSMS also if possible and check whether still you are getting the same.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search