if (not exists (select name from syscolumns where id = object_id('Pub_JYQAttachment') and name = 'PDFName'))   
    Begin

    ALTER TABLE Pub_JYQAttachment ADD
    PDFName nvarchar(1024)

    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PDF
type:text
forbidpost:true' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Pub_JYQAttachment', @level2type=N'COLUMN', @level2name=N'PDFName'

    End


if (not exists (select name from syscolumns where id = object_id('Pub_JYQAttachment') and name = 'PDFNameDescription'))   
    Begin

    ALTER TABLE Pub_JYQAttachment ADD
    PDFNameDescription nvarchar(4000)

    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PDF˵Ã÷
type:text
forbidpost:true' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Pub_JYQAttachment', @level2type=N'COLUMN', @level2name=N'PDFNameDescription'

    End


if (not exists (select name from syscolumns where id = object_id('Pub_JYQAttachment') and name = 'SWFName'))   
    Begin

    ALTER TABLE Pub_JYQAttachment ADD
    SWFName nvarchar(1024)

    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SWFÃû³Æ
type:text
forbidpost:true' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Pub_JYQAttachment', @level2type=N'COLUMN', @level2name=N'SWFName'

    End