SQL - DELETE * FROM TABLE ???

[omarswan]

Could someone give me a VB example of how to use the SQL - DELETE * FROM TABLE.

------------------
OmarSwan

omarswan@yahoo.com

http://omarswan.da.ru/ (http://www.omarswan.cjb.net/)

"Jesus is Lord"

[Clunietp]

To delete all rows from a table:

Delete from MyTable

To delete all rows that meet a criteria:

Delete from MyTable where MyField = MyValue