In memory DDL
torsten.strauss
Posts: 271 Silver 3
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
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
Thanks for your post! We've managed to reproduce this issue and are looking into it now.
James
Redgate Software
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