Is this syntax correct?

• Ram Ganesan

  SSC Enthusiast

  Points: 146

  More actions

  August 11, 2004 at 8:04 am

  #86280

  Hello,

  I am trying to delete all records in all tables in a single database. Which of these stored procedure syntax is correct for doing that?

  exec sp_msforeachtable 'truncate table tablename'

  or

  exec sp_msforeachtable 'delete table tablename'

   

  Also...I am assuming that these stored procedures would NOT alter any of those sytem(sys) tables in the database.

   

  Thanks.

  Ram

  ---

  Thanks,

  Ram Ganesan
  

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  August 11, 2004 at 10:34 am

  #518536

  Please don't cross (double) post. You have this posted elsewhere on this site and have received responses there.

  -SQLBill