UFN_SCHEMA_TABLE_GETDATEEXTENDEDPROPERTY

Returns the given date extended property from the given table.

Return

Return Type
datetime

Parameters

Parameter	Parameter Type	Mode	Description
@TABLENAME	nvarchar(128)	IN
@PROPERTYNAME	nvarchar(128)	IN

Definition

Copy



            create function dbo.UFN_SCHEMA_TABLE_GETDATEEXTENDEDPROPERTY
            (
                @TABLENAME nvarchar(128),
                @PROPERTYNAME nvarchar(128)
            ) 
            returns datetime
            with execute as caller
            as

            begin
                declare @VALUE datetime;

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

                return @VALUE;
            end