USP_SCHEMA_VIEW_SETCOLUMNCOMMENT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TYPE | nvarchar(128) | IN | |
| @VIEWNAME | nvarchar(128) | IN | |
| @COLUMNNAME | nvarchar(128) | IN | |
| @COMMENT | nvarchar(4000) | IN |
Definition
Copy
create procedure [BBDW].[USP_SCHEMA_VIEW_SETCOLUMNCOMMENT]
@TYPE nvarchar(128),
@VIEWNAME nvarchar(128),
@COLUMNNAME nvarchar(128),
@COMMENT nvarchar(4000)
as
declare @VALUE sql_variant
select @VALUE = value from fn_listextendedproperty(@TYPE, N'SCHEMA', N'BBDW', N'view', @VIEWNAME, N'COLUMN', @COLUMNNAME)
if @VALUE is null
-- property doesn't exist, so add it
exec sys.sp_addextendedproperty @TYPE, @COMMENT, N'SCHEMA', N'BBDW', N'view', @VIEWNAME, N'COLUMN', @COLUMNNAME
else
-- property already exists, so update it
exec sys.sp_updateextendedproperty @TYPE, @COMMENT, N'SCHEMA', N'BBDW', N'view', @VIEWNAME, N'COLUMN', @COLUMNNAME