UFN_SCHEMA_TABLE_GETCOMPUTEDCOLUMNISPERSISTED

                create function dbo.UFN_SCHEMA_TABLE_GETCOMPUTEDCOLUMNISPERSISTED (
                    @TABLENAME nvarchar(128), 
                    @COLUMNNAME nvarchar(128)
                ) returns bit
                with execute as caller
                as
                    begin
                        declare @value bit;   

                        select 
                            @value = cast(is_persisted as bit) 
                        from 
                            sys.computed_columns
                        where 
                            object_id = object_id(@TABLENAME)
                        and 
                            [name] = @COLUMNNAME;

                        select @value = case when @value is null then 0 else @value end

                        return @value
                    end