deletion of table

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  October 20, 2009 at 5:56 am

  #212496

  how can we delete the all the user tables and SP'S from a database ?

• ramuvanparti

  SSCrazy

  Points: 2368

  More actions

  October 20, 2009 at 6:02 am

  #1068109

  if your using 2005

  then

  select 'drop table '+table_schema+'.'+table_name from information_schema

  select 'drop procedure '+routine_schema+'.'+routine_name from information_schema.ROUTINES

  where ROUTINE_TYPE ='procedure'

  this will generate drop script.

  or open SSMS open database and select tables folder and press f7 key select all user table press del button 🙂

  similarly procedures