sql_add_remove_descripton

DECLARE @table VARCHAR(50) ,

    @field VARCHAR(50)

SELECT  @table = MIN(name)

FROM    dbo.sysobjects

WHERE   xtype = 'U'

WHILE @table IS NOT NULL

    BEGIN

        SELECT  @field = MIN(COLUMN_NAME)

        FROM    INFORMATION_SCHEMA.COLUMNS

        WHERE   TABLE_NAME = @table

        PRINT ( @table + '==============' )

        WHILE @field IS NOT NULL

            BEGIN

                PRINT @field

                EXEC sp_addextendedproperty 'MS_Description',

                    '請把字段描述填上', 'schema', 'dbo',

                    'table', @table, 'column', @field

--                EXEC sp_dropextendedproperty 'MS_Description', 'schema', 'dbo',

--                    'table', @table, 'column', @field

                SELECT  @field = MIN(COLUMN_NAME)

                FROM    INFORMATION_SCHEMA.COLUMNS

                WHERE   TABLE_NAME = @table

                        AND COLUMN_NAME > @field

            END

        SELECT  @table = MIN(name)

        FROM    dbo.sysobjects

        WHERE   xtype = 'U'

                AND name > @table  

    END