Skip to main content
Skip table of contents

Create translation table Azure SQL

Within an Azure SQL database, the stored procedure sp_MSforeachdb is not present. With the following command it can be created and the creation of a translation table is possible.

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.