USP_SCHEMA_VIEW_SETVIEWCOMMENT

create procedure [BBDW].[USP_SCHEMA_VIEW_SETVIEWCOMMENT]
@VIEWNAME nvarchar(128),
@COMMENT nvarchar(4000)
as
  declare @VALUE sql_variant

  select @VALUE = value from fn_listextendedproperty(N'MS_Description', N'SCHEMA', N'BBDW', N'view', @VIEWNAME, default, default)

if @VALUE is null
  -- property doesn't exist, so add it
  exec sys.sp_addextendedproperty N'MS_Description', @COMMENT, N'SCHEMA', N'BBDW', N'view', @VIEWNAME
else
  -- property already exists, so update it
  exec sys.sp_updateextendedproperty N'MS_Description', @COMMENT, N'SCHEMA', N'BBDW', N'view', @VIEWNAME