USP_SCHEMA_TABLE_CLEARTABLECOMMENT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TABLENAME | nvarchar(128) | IN |
Definition
Copy
CREATE procedure [dbo].[USP_SCHEMA_TABLE_CLEARTABLECOMMENT]
@TABLENAME [nvarchar](128)
with execute as caller
as
if exists (
--select value from fn_listextendedproperty(N'MS_Description', N'SCHEMA', N'dbo', N'table', @TABLENAME, null, null)
select ep.[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'MS_Description'
)
exec sp_dropextendedproperty N'MS_Description', N'SCHEMA', N'dbo', N'table', @TABLENAME, null, null;