How can we help you today? How can we help you today?

In memory DDL

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
torsten.strauss
0

Comments

2 comments

Sort by
  • James R
    Hi Torsten,

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

    James
    James R
    0
  • torsten.strauss
    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
    torsten.strauss
    0

Add comment

Please sign in to leave a comment.