15

I am using visual studio 2013 and trying to learn local database operations. I have created a database using VS and create tables. But I cannot rename table names. There is no such a option anywhere or I cannot see. I searched but find nothing.

Could anyone show me how to rename table using 'VISUAL STUDIO 2013 SSDT'

enter image description here

Omer
  • 8,194
  • 13
  • 74
  • 92

1 Answers1

16

Open the table, highlight the table name in the T-SQL portion of the window, click the SQL menu, then choose Refactor and Rename. You probably want to preview changes while you're at it to see what will be affected.

Peter Schott
  • 4,521
  • 21
  • 30
  • 1
    There is no `SQL` menu. – Ian Boyd Jun 25 '16 at 20:07
  • 2
    There have been a couple of changes to the interface. However, if I open a table and select a column, I do see a "SQL" menu with a "Refactor" option under that. I can also right-click the column and get a Refactor option. Ctrl+R,R is the shortcut key that should be bound to a refactor/rename action. If none of those are working, your SSDT may need to be re-installed or updated. – Peter Schott Jun 27 '16 at 16:40