Data Deletion from a TABLE

[pmcmicha]

I have a table that I need to delete records from, but my syntax is incorrect, could someone please correct this:

1> DELETE * FROM {TABLE} WHERE {ARG}="{VALUE}"
2> GO

I am getting this error:

Msg 102, Level 15, State 1:
Server 'SYBASE', Line 1:
Incorrect syntax near '*'.

Thanks.

 

[karluk]

Just leave out the *. It's not used in delete statements. You may also have to use single quotes. At least that's what is used in Oracle.

DELETE FROM {TABLE} WHERE {ARG}='{VALUE}'

 

[pmcmicha]

Thanks, that worked out great.