Post reply

add a column to an existing table

  • July 8, 2008 at 11:51 am

    #193529

    Hi all,

    I have the following:

    alter table clients

    Add column SceneFlag [char](1) NOT NULL DEFAULT 'Y'

    I always get the following message:

    Msg 156, Level 15, State 1, Line 2

    Incorrect syntax near the keyword 'column'.

    I don't get it. where did it go wrong.

    Betty

  • July 8, 2008 at 12:00 pm

    #839704

    Try this:

    alter table clients

    Add SceneFlag [char](1) NOT NULL DEFAULT 'Y'

    😎

  • July 8, 2008 at 12:40 pm

    #839730

    Lynn,

    Thank you so much for the help. My mind is not here today.

    Sincerely

    Betty

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply