USP_SCHEMA_TABLE_SETDATEEXTENDEDPROPERTY

Sets a date extended property on the given table.

Parameters

Parameter	Parameter Type	Mode
@TABLENAME	nvarchar(128)	IN
@DATE	datetime	IN
@PROPERTYNAME	nvarchar(128)	IN

Definition

Copy



            create procedure dbo.USP_SCHEMA_TABLE_SETDATEEXTENDEDPROPERTY
            (
                @TABLENAME nvarchar(128),
                @DATE datetime,
                @PROPERTYNAME nvarchar(128)
            )
            as
                set nocount on;

                declare @VALUE sql_variant;

                select @VALUE = VALUE from fn_listextendedproperty(@PROPERTYNAME, N'SCHEMA', N'dbo', N'table', @TABLENAME, default, default);

                if @value is null
                    -- property doesn't exist, so add it

                    exec sys.sp_addextendedproperty @PROPERTYNAME, @DATE, N'SCHEMA', N'dbo', N'table', @TABLENAME
                else
                    -- property already exists, so update it

                    exec sys.sp_updateextendedproperty @PROPERTYNAME, @DATE, N'SCHEMA', N'dbo', N'table', @TABLENAME