Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to check/view data in SQL DB in Microsoft Azure

I have a web app in azure which let user to input some data. I want to save them in sql db which I created in azure. Is there a way to check/view the entered data . I am referring to something like "mysql workbench for mysql"

like image 998
Madhavi Avatar asked Oct 04 '16 05:10

Madhavi


People also ask

How do I check SQL data in Azure?

Select your DB and then "Query editor" in the menu and start querying. Show activity on this post. You can download sql server management studio to access your data. Also you can you Visual Studio Community Edition or Visual Code.

How do I view data in SQL database?

Right-click the Products table in SQL Server Object Explorer, and select View Data. The Data Editor launches. Notice the rows we added to the table in previous procedures. Right-click the Fruits table in SQL Server Object Explorer, and select View Data.

How can I see view in database?

Get view properties by using Object ExplorerIn Object Explorer, select the plus sign next to the database that contains the view to which you want to view the properties, and then click the plus sign to expand the Views folder. Right-click the view of which you want to view the properties and select Properties.

Does Azure SQL support views?

YES ,The code proves that the Azure SQL supports automatic use of indexed views without specifying the NOEXPAND hint.


2 Answers

You can download sql server management studio to access your data. Also you can you Visual Studio Community Edition or Visual Code.

Below is the link for download

http://go.microsoft.com/fwlink/?LinkID=828615

you also need to configure the sql database firewall to get access to your database. A Step by Step tutorial to configure that can be found in the following URL

https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/

like image 94
Julian Castiblanco Avatar answered Sep 28 '22 07:09

Julian Castiblanco


You may also view the data in your browser using Azure Portal

Select your DB and then "Query editor" in the menu and start querying.

...

like image 25
Ferdinand Fejskid Avatar answered Sep 28 '22 08:09

Ferdinand Fejskid