Each version of SQL Server potentially adds new columns to the DMVs. These new columns are available even if you change the compatibility level of the database to a previous version.
Is there a list somewhere that shows which columns are available for a given version of SQL Server?
Best Answer
Correct, and since each CU is technically a new version this can happen inside of major version releases.
While this may not be in the spirit of the question asked, there technically is an answer which is to use the system tables. For example, what columns does
sys.availability_groups
currently have in this version (14.0.3037):Will output:
More in the spirit of the question, Docs is your best source for columns based on version outside of your own queries.