CODEWITHSUNDEEP
azureazure-mobile-services
petros
petros

Reputation: 715

Azure Mobile service database row count

I have a free mobile service on Azure and there are 3 tables. Can I somehow get number of rows in each table (using Azure portal or code)?

Upvotes: 0

Views: 46

Answers (1)

Jeremy Hutchinson
Jeremy Hutchinson

Reputation: 2045

If you go to https://manage.windowsazure.com and open your database there

  • click on the the little blue cloud to the left of the "Dashboard"
  • at the bottom will be a section titled "Connect to your database"
  • clock on the "Run Transact-SQL queries against your SQL database (this may prompt you to add your ip to the allowed ips in the firewall)
  • Log in to your database

From there you can run queries against your database such as

select count(1) from [name of your table]

Upvotes: 1

Related Questions