# Alter Table not seeing Changes

**URL:** <https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740>\
**Category:** Toad for SQL Server\
**Created:** [July 6, 2026, 2:20pm UTC](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740 "2026-07-06T14:20:43Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![michael.r.hinkle](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michael.r.hinkle/32/283_2.png) [@michael.r.hinkle](https://forums.toadworld.com/u/michael.r.hinkle)\
**Post date:** [July 6, 2026, 2:20pm UTC](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740/1 "2026-07-06T14:20:43Z")

</div>

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](https://global.discourse-cdn.com/quest/original/3X/7/e/7e373291771e405c7655b2b53fc77611d219fe30.png)

 ![image](https://global.discourse-cdn.com/quest/original/3X/f/9/f9793a79041b83e9a5566c834bf8fdb29de29aee.png)

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

---

<div class="post-metadata">

**Author:** ![Gita.Sharifi](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gita.sharifi/32/16973_2.png) [@Gita.Sharifi](https://forums.toadworld.com/u/Gita.Sharifi)\
**Post date:** [July 6, 2026, 8:32pm UTC](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740/2 "2026-07-06T20:32:58Z")

</div>

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](https://global.discourse-cdn.com/quest/original/3X/f/3/f364afb008bd2edd9a46845c00037004d7108c73.jpeg)

 ![2026-07-06_13-27-47](https://global.discourse-cdn.com/quest/original/3X/4/4/443cb9ebe2721f3035c21b48c82848efbbacc051.jpeg)

---

<div class="post-metadata">

**Author:** ![michael.r.hinkle](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michael.r.hinkle/32/283_2.png) [@michael.r.hinkle](https://forums.toadworld.com/u/michael.r.hinkle)\
**Post date:** [July 8, 2026, 3:10pm UTC](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740/3 "2026-07-08T15:10:11Z")

</div>

@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](https://global.discourse-cdn.com/quest/original/3X/9/2/92442a7c510cc976abe0b50421ad23d72dc9ca9e.png)

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.

---

<div class="post-metadata">

**Author:** ![Gita.Sharifi](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gita.sharifi/32/16973_2.png) [@Gita.Sharifi](https://forums.toadworld.com/u/Gita.Sharifi)\
**Post date:** [July 13, 2026, 6:31pm UTC](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740/4 "2026-07-13T18:31:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![aleksandar.mitrovic](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@aleksandar.mitrovic](https://forums.toadworld.com/u/aleksandar.mitrovic)\
**Post date:** [July 13, 2026, 9:44pm UTC](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740/5 "2026-07-13T21:44:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![michael.r.hinkle](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michael.r.hinkle/32/283_2.png) [@michael.r.hinkle](https://forums.toadworld.com/u/michael.r.hinkle)\
**Post date:** [July 17, 2026, 6:52pm UTC](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740/6 "2026-07-17T18:52:11Z")

</div>

@aleksandar.mitrovic

Assuming the issue is related to the fact Microsoft is reporting a really old version from Azure, will the fix being applied for this also fix the issue in the following post?

> [@LEAST and GREATEST not recognized/highlighted in Editor](https://forums.toadworld.com/t/least-and-greatest-not-recognized-highlighted-in-editor/61735):
>
> SQL Server supports LEAST and GREATEST functions since 2022. They appear to be missing from the internal highlighting dictionary as they do not get treated as built-in functions:

---

<div class="post-metadata">

**Author:** ![aleksandar.mitrovic](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@aleksandar.mitrovic](https://forums.toadworld.com/u/aleksandar.mitrovic)\
**Post date:** [July 21, 2026, 3:49pm UTC](https://forums.toadworld.com/t/alter-table-not-seeing-changes/61740/7 "2026-07-21T15:49:41Z")

</div>

This is a separate issue

The Azure SQL Alter Table issue was logged as TSS-3126 and is related to detecting changes to existing columns in the Alter Table dialog

The fix for TSS-3126 is not addressing that highlighting issue
