Create translation table Azure SQL
In an Azure SQL Database, the stored procedure sp_MSforeachdb is not available by default. However, you can create it using the following command, which allows for the creation of a translation table.
CREATE PROCEDURE sp_MSforeachdb(@cmd AS NVARCHAR(MAX))
AS
select db_name(), *
from sys.schemas
where lower(name) not in ('guest', 'information_schema', 'sys','db_owner','db_accessadmin','db_securityadmin', 'db_ddladmin', 'db_backupoperator', 'db_datareader','db_datawriter','db_denydatareader','db_denydatawriter')
GO