I have SQL Server 2016 Enterprise edition, I restored the DB's to SQL Server 2019 Enterprise edition. But I want to check if I can restore it in SQL Server 2019 Standard.
if I run the DMV sys.dm_db_persisted_sku_features in SQL Server 2019 Enterprise, the results that returns: Compression, Partitioning, ColumnStoreIndex
which means I can't downgrade to standard edition. but according to Microsoft documentation SQL Server 2019 Standard supports the these features. so why these results appears in sys.dm_db_persisted_sku_features?