USP_SCHEMA_TABLE_CLEARTABLETRANSLATIONFIELD
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TABLENAME | nvarchar(128) | IN |
Definition
Copy
CREATE procedure [dbo].[USP_SCHEMA_TABLE_CLEARTABLETRANSLATIONFIELD]
@TABLENAME [nvarchar](128)
with execute as caller
as
if exists (
select value from
sys.extended_properties as ep
where ep.[class]=1 and ep.major_id=OBJECT_ID(@TABLENAME) and ep.minor_id=0 and ep.[name] = N'BB_TRANSLATIONFIELD'
)
exec sp_dropextendedproperty N'BB_TRANSLATIONFIELD', N'SCHEMA', N'dbo', N'table', @TABLENAME, null, null;