Home Forums SQL Server 7,2000 T-SQL extended property for all columns of all tables RE: extended property for all columns of all tables

  • [p]Yes. I put everything in MS_Description because this is the only thing that is accessible to SSMS. I then put a YAML structure into the string so I can do lists and sections.[/p]

    [p]The section between the /** **/ is placed into, or updated to, the extended property by an automated process. [/p]

    [font="Courier New"]

    IF OBJECT_ID(N'IsSpace') IS NOT NULL

       DROP FUNCTION IsSpace

    GO

    CREATE FUNCTION dbo.[IsSpace] (@string VARCHAR(MAX))  

    /**

    summary:   >

                          IsSpace string Function Returns Non-Zero if all characters

                          in s are whitespace characters, 0 otherwise.

    example:

         - code:    Select dbo.IsSpace('how many times must i tell you')

         - code:    Select dbo.IsSpace(' <>[]{}"!@#$%9  )))))))')

         - code:    Select dbo.IsSpace(' ????/>.<,')*/

    returns:     integer:  1  IF whitespace, otherwise 0

    **/

    RETURNS INT

    AS BEGIN

          RETURN CASE WHEN PATINDEX(

                  '%[A-Za-z0-9-]%', @string  COLLATE Latin1_General_CS_AI

                                    ) > 0 THEN 0

                      ELSE 1

                 END

       END

    GO

    [/font]

    Best wishes,
    Phil Factor