Interviews - C# Corner

Amol Sarkate
How to reaname table name without using sp_Rename in sql server..?
By Amol Sarkate in .NET onJun 23 2015
  • Umamaheswara Rao Dasari
    Jun, 2015 29

    Right Click on table object and select Rename option, change the table name.

    • 3
  • Amol Sarkate
    Jul, 2015 13

    Nidhin vs sar i think ALTER TABLE table_name RENAME TO new_table_name;this command used for oracle not in sql server

    • 1
  • Amol Sarkate
    Jul, 2015 3

    using query it not possible....!!!

    • 1
  • Pankaj  Kumar Choudhary
    Jul, 2015 2

    1. Using Right Click on Table or using F2 key

    • 1
  • Vaibhav Agarwal
    Oct, 2015 26

    You can do it in Sql Server Exec sp_rename 'dbo.old_tablename' ,'new_tablename';

    • 0
  • Rahul Prajapat
    Jul, 2015 30

    By right click on table then rename option or by pressing F2 key

    • 0
  • Abhik Singh
    Jul, 2015 27

    open your UI and edit it from server explorer

    • 0
  • Joe Wilson
    Jul, 2015 21

    Hi, you can right click on the table and use rename part to change the name of that,easily.

    • 0
  • Nidhin Vs
    Jul, 2015 8

    Try this:ALTER TABLE table_nameRENAME TO new_table_name;

    • 0
  • srinu vasarao
    Jul, 2015 5

    right click on table and select rename option.....

    • 0
  • Munesh Sharma
    Jun, 2015 28

    http://sqlandme.com/2013/03/04/sql-server-how-to-rename-tablecolumn-in-sql-server/

    • 0
  • Sujeet Suman
    Jun, 2015 26

    Select table name from database treeview & right click on table name then rename it.

    • 0

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS