drop column problem

Discussion in 'Databases' started by Jamie18, Feb 8, 2008.

  1. #1
    i'm using mssql server.

    trying to execute this statement from the query analyzer

    Alter Table phone_bak
    drop column wps_status

    and i get this error

    Server: Msg 170, Level 15, State 1, Line 2
    Line 2: Incorrect syntax near 'wps_status'.

    anyone know what's going on?
     
    Jamie18, Feb 8, 2008 IP