sp_MSforeachtable script for Azure Sql
Azure Sql databases do not come with a lot of the adminstration stored procedures that are part of a local instance install.
sp_MSforeachtable is a handy sp that allows you to iterate through specified objects. It is considered an undocumented feature, so may disappear, but can easily be reproduced.
You may also need sp_MSforeach_worker
EXEC sp_MSforeachtable 'SELECT ''?'' TableName, Count(1) Records FROM ?'