How to rename table using SSDT in Visual Studio
Asked Answered
S

1

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

Sig answered 22/3, 2014 at 12:35 Comment(3)
Duplicate of #20539380Gazelle
I know but I am looking for GUI solutionSig
The other question's accepted answer does not answer the question. Question reasked to hopefully get an answer.Nolannolana
H
17

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.

Husbandry answered 23/3, 2014 at 13:18 Comment(2)
There is no SQL menu.Nolannolana
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.Husbandry

© 2022 - 2024 — McMap. All rights reserved.