关于azure:如何更换Azure-SQL-DB-blob-storage-credentials

通过Azure Data Studio等工具登录到指标DB，执行以下SQL删除以后的credentials。

DROP EXTERNAL DATA SOURCE BlobStorageDataSource;DROP DATABASE SCOPED CREDENTIAL BlobAccessCredential;

执行以下SQL创立一个新的credentials（将Placeholder替换为实在环境的值）。

• PLACEHOLDER_BLOB_SHARED_ACCESS_SIGNATURE: storage SAS token
• PLACEHOLDER_BLOB_NAME: storage name

CREATE DATABASE SCOPED CREDENTIAL BlobAccessCredentialWITH IDENTITY = 'SHARED ACCESS SIGNATURE',SECRET = 'PLACEHOLDER_BLOB_SHARED_ACCESS_SIGNATURE'; CREATE EXTERNAL DATA SOURCE BlobStorageDataSourceWITH (TYPE = BLOB_STORAGE,    LOCATION = 'https://PLACEHOLDER_BLOB_NAME.blob.core.windows.net',    CREDENTIAL= BlobAccessCredential);