USP_SCHEMA_TABLE_CLEARCOLUMNENUMVALUES

CREATE procedure [dbo].[USP_SCHEMA_TABLE_CLEARCOLUMNENUMVALUES]

    @TABLENAME [nvarchar](128),
    @COLUMNNAME [nvarchar](128)

with execute as caller

as

if exists (

    select ep.value from 
    sys.extended_properties as ep
    inner join sys.columns as c on c.object_id=ep.major_id and c.column_id=ep.minor_id
    where 
    ep.class=1
    and
    ep.major_id=OBJECT_ID(@TABLENAME,'U')
    and 
    ep.minor_id > 0
    and
    ep.[name] = N'BB_COLUMNENUMVALUES'
    and 
    c.[name]=@COLUMNNAME
)
    exec sp_dropextendedproperty N'BB_COLUMNENUMVALUES', N'SCHEMA', N'dbo', N'table', @TABLENAME, N'COLUMN', @COLUMNNAME;