We will be syncing data from Dynamics 365 to an Azure Data Warehouse, and I got a request from management to find out what columns in tables we will be syncing over have no data.
Our environment is very heavily customized.
I have access to SSMS environment and the DataVerse that way, but INFORMATION_SCHEMA is not available there.
Anybody have any code or a trick to figure out what columns in a given table, or a list of tables, are blank?
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
95
