How does one name or rename a Table in Visual Studio? I am having a lot of troub

Question

How does one name or rename a Table in Visual Studio? I am having a lot of trouble with making a Personnel Database in C# in Visual Studio and I don't know what I'm doing. I'm trying to follow along with the answer provided on this site but I can't get the Server Explorer to work correctly. I just got done installing SQL things on my computer to do this assignment. How do I save a table and get it to show up in the Server Explorer? How do I rename a Table? I've done Add New Table but it doesn't save it to the Server Explorer and it won't let me save it as a Visual Studio file. Please help me. I am having a massive panic attack over this.

Explanation / Answer

Open sql query panel and rename table through the sql query

below is the sql query for rename table

use 'databasename'

Go

exec sp_rename 'TableToRename' , 'NameOfTheTable'

Go

databasename is the user database like [C:USERSJOHNDESKTOPEmployee.MDF]

sp_rename is builtin procedure,

TableToRename is existing table name,

NameOfTheTable is the name that want to give

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.