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

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

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

1. Using Right Click on Table or using F2 key

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

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

open your UI and edit it from server explorer

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

Try this:ALTER TABLE table_nameRENAME TO new_table_name;

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

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

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