Deleting user tables

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  March 22, 2004 at 10:58 pm

  #110814

  Is there any command like Drop all tables which will delete the all the suer table from a database.

  Or are there any alternative

   

  Thankx

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Amit Jethva

  SSCarpal Tunnel

  Points: 4707

  More actions

  March 23, 2004 at 12:26 am

  #499953

  exec sp_MSforeachtable ' drop table ? '

  
  

  -- Amit

  ---

  
  "There is no 'patch' for stupidity."

  ---

  
  Download the Updated SQL Server 2005 Books Online.

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  March 23, 2004 at 12:45 am

  #499959

  That means I have to right a code for that? isn't it?

  Anyway Thankx

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/