What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    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
  • Options
    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.