enterprise manager: clearing a table

how can i clear a table with enterprise manager? i dont to delete the the table .. just delete all clear all records .. should be an easy question .. i'm not really look for a query .. but more for a menu option in enterprise manager .. i found the delete in the menu .. but i think that is delete table function.
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
there is no menu option for that in sql 2000 enterprise manager
Amien90Author Commented:
really .. hmm .. ok .. only with a query then?

with what query can i delete all records .. and where can i drop that query?
Scott PletcherSenior DBACommented:


Or, if that doesn't work:

DELETE FROM tablename
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>. and where can i drop that query?
when you have selected the table, check out the tools menu -> query analyser.
it will be connected to the same database, and you simply run the statements suggested by ScottPletcher
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.