Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

In memory DDL

edited December 20, 2016 5:15AM in SQL Prompt
Hi!

The following statements are not supported by the IntelliSense.
Would be nice to add the functionality - thanks!

DROP TABLE IF EXISTS dbo.Product;
GO
CREATE TABLE dbo.Product
(
ID int NOT NULL
, Code varchar(10) NULL
, Description varchar(200) NOT NULL
, Price float NOT NULL
, INDEX ID HASH (ID) WITH (BUCKET_COUNT = 100)
)
WITH (MEMORY_OPTIMIZED = ON, DURABILITY = SCHEMA_ONLY);
GO

--add an index
ALTER TABLE dbo.Product ADD
ADD
--intelliSense not working
INDEX NCL_Product_Description (DESCRIPTION);
GO

--drop an index
ALTER TABLE dbo.Product
DROP
--intelliSense not working
INDEX NCL_Product_Description;
GO

Comments

  • James RJames R Posts: 104 Silver 4
    Hi Torsten,

    Thanks for your post! We've managed to reproduce this issue and are looking into it now.

    James
    Software Engineer
    Redgate Software
  • Hi James!

    It seems that in memory DDL statements are not supported currently in most of the cases
    Would be cool to see this in the next release...

    Thanks!

    Another example:

    ALTER TABLE dbo.Product
    --no intelliSense
    ALTER INDEX PK__Product__357D0D3F0107568F REBUILD WITH(BUCKET_COUNT = 32);
    GO
Sign In or Register to comment.