Hi
DELETE FROM <TABLE>
[WHERE <Condition>]


If you are trying to delete all the rows then use
TRUNCATE TABLE <TABLE NAME>

was this the one u are looking for?

--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---------------------------------------



[quoted text, click to view]