SSMS Delete vs T-SQL DROP

• MikeRen

  Ten Centuries

  Points: 1295

  More actions

  January 17, 2011 at 4:48 am

  #143008

  Hi,

  Via SSMS I am able to Delete a table. I could also script a DROP statement, but which one is a better way of removing the object and why?

  My initial thoughts are that they are the same, the only differrence being that a DROP statement can be scripted whilst a SSMS delete action must be manually executed.

  How does this sound?

  Mike

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 17, 2011 at 5:12 am

  #1274195

  SSMS executes a DROP TABLE against SQL when you say select 'delete table'

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  January 17, 2011 at 5:12 am

  #1274196

  They should be the same.

  If you go to SSMS and delete something, you'll get the Delete Object window. At the top, you have a Script button. If you click this, you script out the action that you wanted to take with SSMS. You'll see that the script contains a DROP statement.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• MikeRen

  Ten Centuries

  Points: 1295

  More actions

  January 17, 2011 at 5:16 am

  #1274197

  Sounds like my initial thoughts are confirmed.

  Thanks for replying.

  Mike