How to rename a Table in Sql Server

Posted on January 2, 2012 by vivekjohari
To rename a column in a SQL Table following command can be reused:
SP_RENAME  ‘old table name’, ‘New table name’

For example, if we want to rename the table from employee to employeemaster, following command can be used.

SP_RENAME  ’employee’, ’employeemaster’

This command will rename the table from employee to employeemaster.

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in SQL Basic Concepts, SQL Server and tagged , . Bookmark the permalink.

32 Responses to How to rename a Table in Sql Server

  1. Vimal Kumar Prajapati says:
    August 13, 2014 at 10:47 am

    Nice one…
    I think its Rename instead of remane in title—–"How to remane a Table in Sql Server" 🙂

    Reply
  2. admin says:
    August 14, 2014 at 10:52 am

    Thanks again..:-)
    Corrected

    Reply

  3. Pingback: Lithuanian translator

  4. Pingback: crypto

  5. Pingback: Creative Agency in Orlando

  6. Pingback: slotxo

  7. Pingback: barcatoto

  8. Pingback: เงินด่วน ชัยภูมิ

  9. Pingback: Prediksi HK

  10. Pingback: scam

  11. Pingback: 918kiss download

  12. Pingback: 바카라

  13. Pingback: con heo dat

  14. Pingback: cornhole board distance

  15. Pingback: Samsara Market

  16. Pingback: Empire Market

  17. Pingback: Darknet Markets

  18. Pingback: BQEssentials, LLC

  19. Pingback: link vào m88 mới nhất

  20. Pingback: Skrota bilen gratis

  21. Pingback: www.indoqqpoker.site

  22. Pingback: fifia55

  23. Pingback: kompasqqq

  24. Pingback: พนันบอล

  25. Pingback: https://www.dehir.hu/belfold/europa-road-kft-megbizhato-biztonsagos-es-szemelyre-szabott-szallitmanyozas/2019/01/21/

  26. Pingback: data hk

  27. Pingback: www.2015louisvuittonoutlet.net

  28. Pingback: weight loss Intermittent fasting Apple Cider Vinegar Food wellness oz oprah doctor dr medicince longevity how to lose weight loose wieght wieght lose fittness abs tricks whitney simmons gymshark nikki blackketter female fat loss by body type Weight loss T

  29. Pingback: link vao w88

  30. Pingback: hướng dẫn đăng ký fun88

  31. Pingback: satta king

  32. Pingback: paito sgp

Leave a Reply