USP_SCHEMA_INDEX_CLEARISSYSTEMFLAG
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TABLENAME | nvarchar(128) | IN | |
| @INDEXNAME | nvarchar(128) | IN | |
| @PARENTISVIEW | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_SCHEMA_INDEX_CLEARISSYSTEMFLAG
@TABLENAME nvarchar(128),
@INDEXNAME nvarchar(128),
@PARENTISVIEW bit = 0
with execute as caller
as
declare @parentObjectType nvarchar(max);
if @PARENTISVIEW = 1
set @parentObjectType = N'view';
else
set @parentObjectType = N'table';
if exists (select value from fn_listextendedproperty(N'BB_IsSystem', N'SCHEMA', N'dbo', @parentObjectType, @TABLENAME, N'index', @INDEXNAME))
exec sp_dropextendedproperty N'BB_IsSystem', N'SCHEMA', N'dbo', @parentObjectType, @TABLENAME, N'index', @INDEXNAME