USP_SCHEMA_TABLE_CLEARCOLUMNTRANSLATIONFUNCTION

CREATE procedure [dbo].[USP_SCHEMA_TABLE_CLEARCOLUMNTRANSLATIONFUNCTION]

@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_TRANSLATIONFUNCTION'
  and 
  c.[name]=@COLUMNNAME

)
    exec sp_dropextendedproperty N'BB_TRANSLATIONFUNCTION', N'SCHEMA', N'dbo', N'table', @TABLENAME, N'COLUMN', @COLUMNNAME;