SSMS 18.3.1 IntelliSense does not recognize MOVE TO as a valid option for DROP INDEX
Management Studio, with IntelliSense enabled, does not seem to know that "MOVE TO" is a valid option for the DROP INDEX statement. "MOVE" is underlined in red with a tool tip of:
Incorrect syntax near 'MOVE'.
Yet, it's clearly not invalid since it does work :-).
I have observed this behavior in SSMS 18.3 and 18.3.1.
Not that this should matter, but I have tested with both SQL Server 2017 CU15-GDR and 2019 RC1.
Below is a simple repro script to show that this option truly is valid:
CREATE TABLE [dbo].[MoveTo]
[MoveToID] INT NOT NULL,
[SomethingElse] VARCHAR(50) NULL
CREATE UNIQUE CLUSTERED INDEX [CIXMoveToMoveToID]
ON [dbo].MoveTo ON [PRIMARY];
DROP INDEX [CIXMoveToMoveToID]
WITH (MOVE TO [PRIMARY]);
Sql Quantum Leap ( https://SqlQuantumLeap.com/ )
Solomon Rutzky commented
Just FYI: this is still broken in SSMS 18.4 (15.0.18206.0).