USP_DROPCOLUMNSTOREINDEX
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SCHEMA | nvarchar(255) | IN | |
| @TABLE | nvarchar(255) | IN |
Definition
Copy
create procedure BBDW.[USP_DROPCOLUMNSTOREINDEX] (@SCHEMA nvarchar(255), @TABLE nvarchar(255))
as
declare @CSINDEX nvarchar(255) = (select BBDW.[UFN_GETCOLUMNSTOREINDEXNAME] (@TABLE));
exec BBDW.[USP_DROPOBJECTIFEXISTS] @SCHEMA, @CSINDEX, @TABLE;