Using Data Explorer, I entered the following command against a MS Sql Server table

DELETE FROM [dbo].[tblVendorMessage] WHERE VEN_VENDOR_NAME = "A&EMAN1"

and got the error message "Invalid column name 'A&EMAN1'.

I searched in BOL and found "A change to the table required the table to be recreated. When a table is recreated, the triggers attached to that table are automatically recreated as well." but I'm not sure why deleting a row would require recreating the table.

Can someone tell me what this means and what I need to do?

TIA,