After your Azure-based SQL server has loaded in the SQL server explorer in Visual Studio, you can expand the view to browse specific databases, tables, and columns.
You can also run SQL queries online, in a query editor in the Azure portal. To browse to the query editor, go to <Your Database> -> Tools (on the Overview tab) -> Query editor. From here, you can simply run any SQL query, just as you could from Visual Studio or SQL Server Management Studio, although you cannot browse the structure of your tables and columns.
To create a new table in the TextScoresDB database in Visual Studio, follow these steps:
- To add a new table, right-click on the database name, and choose New Query… as follows:
- In the ...
