How to modify the table name in Server Explorer of Visual Studio

Vs seems to have forgotten to add this function, but when the table name is wrong, it cannot always run into SQL Server Management studio. In fact, it can be solved directly by using SQL statements.

 

1. Right-click the name of the table to be changed in Server Explorer (in fact, any table can be used)

2. Select New query. In the "Add Table" dialog box that appears, do not select any table. Directly close the table.

3. Write in the box that says select from:

Exec sp_rename oldname, newname

Here, oldname/newname is the old and new table names. Note that there is an unreasonable "," in the middle. Maybe there are too few SQL statements.

4. Execute (CTRL + r) and an error will be reported. Ignore this option and select "continue"

5. Successful

 

Click to download the free agile development textbook: Martian agile development manual