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