Alter Table not seeing Changes

Toad for SQL Server
1

I just went into Alter Table to change the length of an nvarchar column. I made the change to the length in the GUI, then went to the SQL Script tab and get the "-- No Changes Detected" message.

image
image866×578 44.1 KB

image
image475×191 14.3 KB

I manually wrote the following which Alter Table should have created:
ALTER TABLE medal.KM_KEY_MESSAGE_DTL
ALTER COLUMN KEY_MESSAGE_NAME NVARCHAR(128);

2

Hi Michael,
I just tried the same steps and Toad generated the script with the updated nvarchar new length. You should have to manually write the script.
Could you let us know the version of your Toad and database. Thanks.

2026-07-06_13-27-37
2026-07-06_13-27-37806×645 95.8 KB

2026-07-06_13-27-47
2026-07-06_13-27-47776×634 52.9 KB

3

@Gita.Sharifi :

I am running Toad for SQL Server DevSuite 26.2.0.44257 (64 bit). SQL Server is Microsoft SQL Azure (RTM) - 12.0.2000.8. It looks like version number is pretty useless when running on Azure:

image
image679×312 30.4 KB

Additionally I have tried several other changes to existing Columns in a table and get the No Changes detected. The only time it picks up changes for me is when I add a new column. I mostly work in Oracle but have a SQL Server DB I am now responsible for and my SQL Server specific knowledge is way lower than my Oracle knowledge.

4

Thanks Michael for the additional details. I'm going to let our development team chime in here for some insight.

5

Thanks Michael. We were able to reproduce this on Azure SQL.

We reproduced the issue on Azure SQL, and we have logged it as a bug under TSS-3126. At the moment, we do not have a reliable workaround inside the Alter Table dialog. The current workaround is to run the ALTER statement manually