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.
Amien90Asked:
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
0
 
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?
0
 
Scott PletcherSenior DBACommented:
Either:

TRUNCATE TABLE tablename

Or, if that doesn't work:

DELETE FROM tablename
0
 
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
0
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.