From the course: Visual Studio Tools for Azure Developers

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Edit database tables

Edit database tables

From the course: Visual Studio Tools for Azure Developers

Start my 1-month free trial

Edit database tables

- [Instructor] Once you are connected to Azure SQL Server in Visual Studio, the standard data tools work as expected. You can find them over here in the SQL Server Object Explorer. I'll drill down into my database. Here it is. And you can see that I can work with tables, views, security, storage, and all the other items you'd expect to work with in SQL Server. In the tables folder, I can see the sample tables from the AdventureWorks database. And I want to look at some items in the Product table, so one way I can look at the details of the Product table is to open up this node and then, I can drill down and learn more about the columns or the keys or the constraints. I can also right-click and choose to view the code, that would be the SQL that creates the table, view the designer and other items. I'll look at View Designer and View Data. I'll start with View Designer. Visual Studio went out and queried the database and returned information about the structure of the table, so I can…

Contents